#1   Report Post  
Jon
 
Posts: n/a
Default Unselect Option Box

I have 2 option boxes in a worksheet, how can I unselect both boxes without
deleting the linked cell reference?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer Karl Schweitzer Excel Discussion (Misc queries) 0 April 7th 05 06:17 PM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 09:57 PM
Filter option vishu Excel Discussion (Misc queries) 1 February 28th 05 01:36 PM
XML Data menu option -- not listed / available. How do you fix thi meingotham Excel Discussion (Misc queries) 1 January 27th 05 09:46 PM
How to protect Option button in worksheet Julie Excel Worksheet Functions 2 January 4th 05 01:01 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"