G Guest May 17, 2005 #1 I have 2 option boxes in a worksheet, how can I unselect both boxes without deleting the linked cell reference?
I have 2 option boxes in a worksheet, how can I unselect both boxes without deleting the linked cell reference?
D Dave Peterson May 18, 2005 #2 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?
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?