how do I clear a dialog box option

G

Guest

I'm using a procedure in Excel 2003 that invokes a dialog box with several
option buttons. When the desired action is completed, the procedure hides
the dialog box. When I use the procedure the next time, the option button is
still selected, so I can't select the same action again. How do I get the
option to clear without manually clicking the "X" to close the box?

Thanks.
 
D

Die_Another_Day

How about trying this before using .Show on the dialog box?
OptionButton1.Value = False
OptionButton2.Value = False 'etc...
frmMyForm.Show

HTH

Die_Another_Day
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top