De-Select an Option button

[Otto Moehrbach]

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

 

[Guest]

Private Sub OptionButton1_Click()
If OptionButton1.Value Then
MsgBox "Clicked"
End If
OptionButton1.Value = False
End Sub

worked for me.

 

[Otto Moehrbach]

Thanks Tom. Otto

Private Sub OptionButton1_Click()
If OptionButton1.Value Then
MsgBox "Clicked"
End If
OptionButton1.Value = False
End Sub

worked for me.

 

[Guest]

This code would need to be entered into each option button code correct?
Thanks