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

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

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

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