Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi guys,
I have a file consisting one command button and two option buttons.what I want to do is by pressing command button, I wanna choose the button that was nat chosen before,in other words,if option button 1 was chosen earlier now i need it be clear and the second option button be selected.I'm trying the following codes but it is not working: If Sheets("Request Form").OptionButton1.Value = True Then Sheets("Request Form").OptionButton2.Value = False Else If Sheets("Request Form").OptionButton1.Value = False Then 'Sheets("Request Form").OptionButton2.Value = True End If End If any comment? thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
option buttons | Excel Worksheet Functions | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Option Buttons | Excel Discussion (Misc queries) | |||
Using 'Option Buttons' | Excel Discussion (Misc queries) | |||
yes/no option buttons | Excel Discussion (Misc queries) |