Userform Optionbuttons

[bahllr]

I have two option buttons on a userform. One says yes and one says no. There are two command buttons (back and next).

If the user selects yes and then clicks the next button, I want it to go to userform2. However, if the user selects NO and then clicks the Next button, I want it to got to userform3.

Is there a way to code this? I don't know how to code if a optionbutton is 'active'?

Any ideas?

 

[andrewk32]

You use the property value to determine if it is active.
Try this code
the optionbuttons are named optYes and optNo

Private Sub cmdNext_Click()
If optNo.Value = True Then
    UserForm3.Show
ElseIf optYes.Value = True Then
    UserForm2.Show
End If
End Sub

 

[bahllr]

Thanks, Andrewk32!

This works perfectly.

Now I know that the property value is true/false!