Multiple Userform

[williamyeow]

Hi i am new to excel VB. can anyone tell me how to link userform to another userform?

My concept for my program
I have set up a userform with a couple of option. after the user has chose the options and click next, userform2 will be activated.

Thanks

[milkyman]

Ok, that's very easy.

If you make a CommandButton on your form and place this code inside it. it wil work.

Private Sub CommandButton1_Click()

UserForm2.Show

End Sub

de command "UserForm2.Show" calls your 2th form.
(i assume that your 2th form is called UserForm2, if not you have to put here the name of your form)

have funn with it......

[NSF12345]

When you have finished with that form, and have a close button, just put "userform2.hide" this hides the 2nd userform. Some people prefer to hide the 1st form when the 2nd form is opend, so they have something like this:

'Code on Form1
private sub Command1.click ()
form1.hide
form2.show
end sub

then when they have finished with the 2nd form they swap the code around to this:

'Code on form2
private sub Command1.click ()
form1.show
form2.hide
end sub

hope tht helps