Unselect Option Box
 

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

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?

Jon wrote:

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

--

Dave Peterson