Unselect Option Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I unselect a cell in Excel? 2
UnSelect the copied to range after copy... 4
unselect cells 2
Make left-to-right default direction 1
Excel files not opening 3
Delete Unselected Rows 2
Problems with cell references 3
Unselect option buttons 2

Back
Top