Solved: Multiple Userforms

[Kindly_Kaela]

I have a feeling I'm using forms wrong, and looking for a little VBA-101 lesson.

The program I'm creating requires several different windows of questions for the user to answer. The user hits NEXT, and a new screen opens. Depending on the users answers, different windows may open.

Currently, I'm creating a new UserForm for each new screen. Ok, now stop laughing and help this gal out. :tongue:

The basic commands I've been using are:



UserForm2.Show
Unload Userform1
UserForm1.Hide (I haven't used this one)


Can anyone please give me some basic lessons on how I should be designing forms? ...along with the commands that go with changing from screen to screen after the user hits NEXT.

If there's anything I'm leaving out, please ask and I'll respond quickly.

Thanks!
Kaela
:cloud9:

P.S. I hope it's ok that I posted this in the EXCEL section too, not sure if the same geniouses go to both sections.

[lucas]

kk......you've cross posted this in the same forum......

http://vbaexpress.com/forum/showthread.php?t=10827

please read this (http://www.excelguru.ca/node/7)
If you wish to post the same question in two forums please provide a link to where you have already asked this question.....

[Kindly_Kaela]

Sorry Luca, I didn't know the cross posting rule.

Everyone, please ignore this post and go to the link above.

Again, my appologies.

:cloud9:

[lucas]

No apology necessary. Many folks don't understand the confusion it causes until it's pointed out. Thanks for understanding.

It's not exactly a rule just consideration for those trying to help.

[lucas]

If we're lucky you will be helping answer questions for others soon and it will become all to clear to you....