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
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
Last edited: