View Single Post
  #3  
Old February 7th 07, 10:46 PM posted to microsoft.public.outlook.program_vba
Twotone
external usenet poster
 
Posts: 7
Default Getting user input using a form and returning to procedure

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.

Ads