Hey, i'm trying to write macros into my excel document for my college work, when I click a command button, i want the form to be cleared ready for fresh data input, and all the option check circles to be set to unchecked.
Clearing the data I can do, but any ideas how to uncheck an option circle?
i tried
Option1.Checked = False
This doesnt work, I'm trying to be logical about this but cant figure it out at all, I know I'll probably have to uncheck each option individually, and i dont have a problem with that, so long as I know how to do it one at a time.
Question
ElectronicRealm
Hey, i'm trying to write macros into my excel document for my college work, when I click a command button, i want the form to be cleared ready for fresh data input, and all the option check circles to be set to unchecked.
Clearing the data I can do, but any ideas how to uncheck an option circle?
i tried
Option1.Checked = False
This doesnt work, I'm trying to be logical about this but cant figure it out at all, I know I'll probably have to uncheck each option individually, and i dont have a problem with that, so long as I know how to do it one at a time.
Any help would be appretiated, thankyou.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts