Hi everyone i have a user form that is triggered by an option button(1) and if user cancels the user form. I need another option button(2) to show that it is selected(true) and option button(1) to show NOT selected (false). I can use either active x or user form option buttons. Would prefer user form buttons. Here is the code I am trying that is NOT working:
Thanks in advance for any help or direction.
sd
Code:
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
UserForm1.Hide
Worksheets("Dashboard").Range("W1") = "RSM"
OptionButton1.Value = True
Application.ScreenUpdating = True
End Sub
Thanks in advance for any help or direction.
sd