Option button on a userform question

[birdieman]

I want to put an option button on a userform and I want the user to choose between "yes" and "no".

1. Do I put one button on the form and then in the code (a "change" event for the OptionButton1, I guess) do what I need done based on whether TRUE ("on") or FALSE ("off")?

2. Or, do I put two buttons on the form and use code for both buttons? If this is the case, how do I make sure they are both not "on" or "off" at the same time?

Or should I use a check box?
thanks

 

[Norie]

If it's Yes/No then it's probably better (easier?) to use a checkbox.

 

[birdieman]

If I want to show the user a yes button and no button, would I group two option buttons inside a frame in order for them to be "grouped" together, and therefore not able for both to be "on" at the same time? Is that correct?

thanks for responding

 

[Norie]

They don't need to be in a frame, you can use their GroupName property to group them.

 

[birdieman]

thank you -- tried it and found out how to link. Which button does the code go into -- does it matter? Then, in the code, I just determine if OptionButton1 is "true" and if so do something, and if not do something else?

 

[Norie]

Do you need code for the buttons themselves?

What are they going to be used for?

 

[birdieman]

the buttons are labeled "automatic" and "manual". If automatic is clicked, then I want to lock a textbox and set its tab stop to false to prevent user input. If "manual" is clicked, then I want to unlock the textbox, set tab stop to true, and allow user input. There may be other stuff, but that is basically it.

In another textbox's code, I want to be able to check the setting in optionbutton1 (or the other one), and if "automatic" is pushed, then i want to do something else.

hope that helps

 

[Norie]

You should put the code in both.

 

[birdieman]

thank you for your help