Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have 2 option boxes in a worksheet, how can I unselect both boxes without
deleting the linked cell reference? |
#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? Jon wrote: I have 2 option boxes in a worksheet, how can I unselect both boxes without deleting the linked cell reference? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) | |||
Second option button disappears when I make another column | Excel Worksheet Functions | |||
Filter option | Excel Discussion (Misc queries) | |||
XML Data menu option -- not listed / available. How do you fix thi | Excel Discussion (Misc queries) | |||
How to protect Option button in worksheet | Excel Worksheet Functions |