link one form to another in the same worksheet

[jaffy]

Hi, i have five forms created from an excel (2003) worksheet - i need to be able to move from one form the the next and dump the data into the worksheet as i go.........the data is all one record on the worksheet - so many questions i had to use five data entry forms to get them all! VB 6.3 used - can anyone give me some clues/help? Thanks, Jaffy

 

[crimson_b1ade]

umm...have you considered using a multipage control in just one userform? you should look into it.

 

[xenou]

Multipage form sounds perfect.

A less optimale solution, depending on how it all works, is to show/hide the forms as you go. When you hide the form, control returns to the procedure that activated it in the first place. You then might show the next form, and so on.

If the forms are "modeless" rather than "modal" you can leave them "open" and switch around among them. I've never tried this myself so I can't speak for the behaviors to expect.

Alex

 

[jaffy]

thanks to Alexander Barnes & Crimson B1lade - i don't know what "modal" and "modeless" mean - I have worked out how to complete one form, dump the data - i just need now to get to the next form (automatically).

Crimson_B1lade - i will investigate the "multipage control" - this sounds like the answer. I only used five forms because I couldn't fit the questions onto one.......

Thanks Heaps - i am off the learn some more! Jaffy