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