Help with Option Button

[Hershel]

Hi! I need a little help about option buttons:
I've this User Form:

and the cod on the command button is:
Private Sub CommandButton_Click()
If OptionButton1 = True Then
If OptionButton4 = True Then
Welcome.Hide
UserForm1.Show
Load UserForm1
ElseIf OptionButton5 = True Then
Welcome.Hide
Load UserForm2
UserForm2.Show
ElseIf OptionButton6 = True Then
Welcome.Hide
Load UserForm3
UserForm3.Show
End If
End If
End Sub

 

[Hershel]

Sorry, the cod works. I just misspelled the name of one of the option buttons!

 

[mikerickson]

I noticed that the Load UserForm1 line comes after the UserForm1.Show line, unlike userform2 or 3.

Is this a typo?

 

[Hershel]

As a beginner I will tell you that it works either way. Maybe a pro can tell another answer...

 

[mikerickson]

Personaly, if I'm going to show a Userform, I don't use the Load statement.

As far as I can see, Showing isn't nesseary, simply referencing a Userform loads it. It is useful in situations where you have multiple instances of the same userform, but normaly I don't find Load useful.