G
Guest
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,
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,