Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Unselect option buttons

I have a worksheet with 2 option buttons that are linked. Is there anyway to
unselect both buttons once one has been selected.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default Unselect option buttons

assuming that once your user checks an option button, another button
is clicked to make something happen...........

private sub commandbutton1_click()

optionbutton1.value = false
optionbutton2.value = false

'your code for what you want done

end sub


hope that helps!
:)
susan


On Sep 12, 3:40*pm, Jasmine wrote:
I have a worksheet with 2 option buttons that are linked. Is there anyway to
unselect both buttons once one has been selected.


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Unselect option buttons

I'd add a third "None/Neither" button

Jasmine wrote:

I have a worksheet with 2 option buttons that are linked. Is there anyway to
unselect both buttons once one has been selected.


--

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
Option Buttons/Radio Buttons John Calder New Users to Excel 7 May 16th 08 03:51 AM
Option buttons: How to get the selected option from a group? naddad Excel Programming 5 December 21st 05 05:09 PM
Navigating between option buttons is not selecting the option drhalter Excel Programming 1 June 3rd 05 02:28 PM
Navigating between option buttons is not selecting the option Gixxer_J_97[_2_] Excel Programming 4 June 2nd 05 02:50 PM
Unselect Option Box Jon Excel Discussion (Misc queries) 1 May 18th 05 01:02 AM


All times are GMT +1. The time now is 07:33 AM.

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

About Us

"It's about Microsoft Excel"