Code to change a radio buttons properties

[Smurfit-Stone]

Hello Board,

I'm trying to write code to clear a user form that has a series of radio buttons. I need to clear the form (template) to use over again. So far I have this.

ActiveSheet.Shapes("OptionButton14").Select

What I need to do now is change the properties.value from true to false. But no matter what I write or record, it doesn't work. I can't use checkboxes, because I need to force the user to select either on or the other in the group of buttons. There are 10 groups with 2 buttons each. I will need to reset the form and have the 10 groups buttons clear. Can anyone help? Thanks in advance.

 

[CWatts]

You can change the value to FALSE such as

OptionButton1.Value = False

or, if you have a "na" button that is grouped with other buttons, you can set that button to true and it will make all others false.

 

[Smurfit-Stone]

THANK YOU, THANK YOU, THANK YOU. It is such a blessing to be able to come to this site and get answers to excel problems. Thanks again!


Sorry, but this bit of code did not work

 

[Smurfit-Stone]

THANK YOU, THANK YOU, THANK YOU. It is such a blessing to be able to come to this site and get answers to excel problems. Thanks again!


Sorry, but this bit of code did not work[/QUOTE]

 

[CWatts]

So, when you say "user form" is it a userform in this sense of the word:
http://www.contextures.com/xluserform01.html

Or is it a worksheet (tab) with some controls on it, and if so, are they active x or form controls?

Given that the code I gave you was for the first example, I'd assume yours is the second.

 

[Datsmart]

Did you change CWatts' code from:
"OptionButton1"
to
"OptionButton14"
to match your button number?