| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
De-Select an Option button
Excel XP & Win XP
I am using Option buttons from the Control Toolbox. When I click on one, a black dot appears in it to signify selection. Fine. But that Option button stays selected until I click on another one and that's not good. How do I de-select (remove the dot) that button so that I can select it again (and trigger code)? I would like that button to be unselected after the code runs. Thanks for your time. Otto |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
De-Select an Option button
Private Sub OptionButton1_Click()
If OptionButton1.Value Then MsgBox "Clicked" End If OptionButton1.Value = False End Sub worked for me. -- Regards, Tom Ogilvy "Otto Moehrbach" wrote: Excel XP & Win XP I am using Option buttons from the Control Toolbox. When I click on one, a black dot appears in it to signify selection. Fine. But that Option button stays selected until I click on another one and that's not good. How do I de-select (remove the dot) that button so that I can select it again (and trigger code)? I would like that button to be unselected after the code runs. Thanks for your time. Otto |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
De-Select an Option button
Thanks Tom. Otto
"Tom Ogilvy" wrote in message ... Private Sub OptionButton1_Click() If OptionButton1.Value Then MsgBox "Clicked" End If OptionButton1.Value = False End Sub worked for me. -- Regards, Tom Ogilvy "Otto Moehrbach" wrote: Excel XP & Win XP I am using Option buttons from the Control Toolbox. When I click on one, a black dot appears in it to signify selection. Fine. But that Option button stays selected until I click on another one and that's not good. How do I de-select (remove the dot) that button so that I can select it again (and trigger code)? I would like that button to be unselected after the code runs. Thanks for your time. Otto |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
De-Select an Option button
This code would need to be entered into each option button code correct?
Thanks "Otto Moehrbach" wrote: Thanks Tom. Otto "Tom Ogilvy" wrote in message ... Private Sub OptionButton1_Click() If OptionButton1.Value Then MsgBox "Clicked" End If OptionButton1.Value = False End Sub worked for me. -- Regards, Tom Ogilvy "Otto Moehrbach" wrote: Excel XP & Win XP I am using Option buttons from the Control Toolbox. When I click on one, a black dot appears in it to signify selection. Fine. But that Option button stays selected until I click on another one and that's not good. How do I de-select (remove the dot) that button so that I can select it again (and trigger code)? I would like that button to be unselected after the code runs. Thanks for your time. Otto |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I select more than one option in a drop down box? | Excel Discussion (Misc queries) | |||
| Select Option button unhide row | Excel Discussion (Misc queries) | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Select option button when have the name as a string | Excel Programming | |||
| Can't select macro button after other button is pressed | Excel Programming | |||
Linear Mode
