how do I clear a dialog box option
How about trying this before using .Show on the dialog box?
OptionButton1.Value = False
OptionButton2.Value = False 'etc...
frmMyForm.Show
HTH
Die_Another_Day
Les wrote:
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.
|