By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,060 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,060 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.

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()


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 ()
end sub

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

'Code on form2
private sub ()
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.