ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unselect option buttons (https://www.excelbanter.com/excel-programming/416969-unselect-option-buttons.html)

Jasmine

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.

Susan

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.



Dave Peterson

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


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com