User Forms in VBA

[Dwight3238]

Hi I'm creating a automation template in Word and I need to use multiple user forms, how do I get the code to open the next form from the previous one?

 

[TonyJollans]

Hi Dwight3238,

Assuming you have a button on the form to go to the next then in the code behind the button put ..

unload me
nameofnextform.show

Enjoy,
Tony

 

[Dwight3238]

Thanks but i guess i wasn't very clear. i need to call the second form and then return back to the original form.

i'm in an IF statement that if the condition is true then i need to open this other form. i can't use an input box since i need to present a list of choices to the user in a combobox. once the choice is made we return to the original form.

Any help would be greatly appreciative.

 

[JPMontreal]

Hi,

Put every things on the same form and then hide or make visible as needed.


Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca

 

[TonyJollans]

Hi Dwight3238,

At whatever point you want you can show a(nother) form just by ..

NewFormName.Show

.. and when the form is closed control will return to the next statement after the Show.

Enjoy,
Tony

 

[Bowers74]

Instead of using multiple user forms, try using the MultiPage Control from the toolbox.

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Dwight3238]

Great your adviced did the trick.

Thanks