Changing option buttons through userforms

[Glory]

There's apparently no easy way to affect an option button on one userform from another.

One userform has one option button and one command button. The other userform has one command button on it.

Clicking the command button on first userform the loads the second userform. Clicking the command button on the second userform is supposed to set the value of the option button on the first userform to "-1" (selected).

Code:

Userform1:

Private sub commandbutton1_click()
   UserForm2.Show
End Sub

UserForm2

Private sub commandbutton1_click()
   Userform1.OptionButton1.Value = -1
End Sub

The end result is that the option button on userform 1 becomes "null", and from time to time messing around with code like this I get an error message that reads "Invalid use of null".

Please help me out with this. I need to be able to affect an option button on a userform from an external userform.

 

[mikerickson]

Try

Private sub commandbutton1_click()
   Userform1.OptionButton1.Value = True
End Sub

Be aware that this will trigger Userform1.OptionButton1's Change event (and its Click event)

 

[Glory]

I don't understand. Am I wrong to be frustrated by this...? Why does VBA's Help say you should set the value to -1 if you sometimes need to set the value to "True"?

How was I supposed to know this?

 

[Glory]

As an aside, it works perfeclty, obviously you knew it would and it does. I don't need to work about the click or change events of the option button.

What if I did (if clicking the option button triggered another form to appear, typically, and I didn't want that form appearing when the option button was altered from another userform)? What would I do then?