I'm sorry if this is an idiotic question but I've looked all over for an
answer.

I have a procedure in Outlook (2003). After a few lines of code, I want to
display a form, get some input from the user and then return to the original
procedure and carry on executing code just below the line where I made the
form open (using the information input by the user).

I cannot work out how to get the form to close and the code to continue
running where it effectively paused to allow the user input on the form.

I can see how to do this using lots of separate modules which call each
other in turn but that seems very clumsy.

Any help would be much appreciated.

Use this method:

MyFormName.Show 1

1 equates to True for the Modal argument, which freezes the form and stops
your code until the form is closed, which will resume code after that method.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Twotone" wrote:

I'm sorry if this is an idiotic question but I've looked all over for an
answer.

I have a procedure in Outlook (2003). After a few lines of code, I want to
display a form, get some input from the user and then return to the original
procedure and carry on executing code just below the line where I made the
form open (using the information input by the user).

I cannot work out how to get the form to close and the code to continue
running where it effectively paused to allow the user input on the form.

I can see how to do this using lots of separate modules which call each
other in turn but that seems very clumsy.

Any help would be much appreciated.

Thank you. Can't understand how I didn't see that in the help screens!

"Eric Legault [MVP - Outlook]" wrote:

Use this method:

MyFormName.Show 1

1 equates to True for the Modal argument, which freezes the form and stops
your code until the form is closed, which will resume code after that method.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Twotone" wrote:

I'm sorry if this is an idiotic question but I've looked all over for an
answer.

I have a procedure in Outlook (2003). After a few lines of code, I want to
display a form, get some input from the user and then return to the original
procedure and carry on executing code just below the line where I made the
form open (using the information input by the user).

I cannot work out how to get the form to close and the code to continue
running where it effectively paused to allow the user input on the form.

I can see how to do this using lots of separate modules which call each
other in turn but that seems very clumsy.

Any help would be much appreciated.