Unselect Option Box

J

Jon

I have 2 option boxes in a worksheet, how can I unselect both boxes without
deleting the linked cell reference?
 
D

Dave Peterson

I used optionbuttons from the control toolbox toolbar.

Then I used a macro that would clear the optionbuttons:

Option Explicit
Sub testme()
With Worksheets("sheet1")
.OptionButton1.Value = False
.OptionButton2.Value = False
End With
End Sub

Have you thought of putting a third button on the worksheet that represents
Neither?
 
Top