Resetting an Option Button in Excel VBA
Posted by Kurt on July 20, 2000 8:03 AM
Hello,
How do you reset Option Buttons when you click on
of them and you may have several on a form? What
is the command in Excel VBA to do this?
Ryan I bet you know the answer!
Thanks!!
Posted by Ryan on July 20, 0100 10:47 AM
Kurt,
I don't know all the answers. Not yet anyway! What do you mean by resetting an option button? Let me know and I'll see if I can pull out an answer.
Ryan
Posted by Kurt on July 20, 0100 11:03 AM
Ryan,
BTW I got the first part figured out about passing
the labels. I had to switch to caption and it worked!
Well bud, you know a lot on the fly! Give yourself
a pat on the back!!
When you click on an option button the dark circle
inside of it still stays on the user form. I want
to be able to clear it so that it can be used the
next time.
I hope this makes more sense and thanks for your
prompt responses!!
Kurt
Posted by Ryan on July 20, 0100 11:11 AM
Kurt,
The option button values are true and false. So if you want to take away the cirlce, Set the button value to False, e.g. OptionButton1.Value = False
I also posted an answer for you question about specifying a SaveAs file type!
Ryan (patting my back :-) )
