Stop VBA execution until form is closed

From: Chris Nebinger (anonymous_at_discussions.microsoft.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 09:52:38 -0700

The way that I usually do this is to open the form in
dialog mode. That causes all code to wait.

My close button doesn't close the form, just hides it so I
can still use the values elsewhere.

Chris Nebinger

>-----Original Message-----
>Hi,
>
>May this is simple, but I have failed so far.
>
>I want to open a form programatically, and then stop
>execution of the procedure for checking data in the form.
>After closing the form (and loading some of the checked
>data in public strings for use elsewhere) the procedure
>should resume automatically and access the public strings
>(for putting them in a Word document).
>Opening the form is no problem, loading the form's data
>to strings on closing works fine, but I did not manage to
>making the procedure wait so that somebody can check and,
>if necessary, edit the form's data.
>
>Is this possible and if yes, how. If No is there a way
>around this problem?
>
>Bakema
>.
>