MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Resetting an Option Button in Excel VBA

Posted by Kurt on July 20, 2000 8:03 AM


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!


Posted by Ryan on July 20, 0100 10:47 AM

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.


Posted by Kurt on July 20, 0100 11:03 AM


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!!


Posted by Ryan on July 20, 0100 11:11 AM


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 :-) )