By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,810 Members | 783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,810 IT Pros & Developers. It's quick & easy.

Multiple Userform

P: 1
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
Sep 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: 12
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......
Sep 14 '06 #2

P: 21
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
Sep 15 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.