| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I clear a dialog box option
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I clear a dialog box in Excel that is not a comment? | Excel Discussion (Misc queries) | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| Clear Option Button Selections | Excel Discussion (Misc queries) | |||
| excel vba option dialog box | Excel Discussion (Misc queries) | |||
| In Excel Tools Menu Option Dialog box don't open | Excel Discussion (Misc queries) | |||
Linear Mode
