Background execution of Form

[Vince]

Hi all,

When my macro is running, I'ld like to show a wait message (a custom form)
to the user and unload it after the macro's done.

For instance:

MyWaitMessageForm.show '1

call ComplexMacro '2

Unload MyWaitMessageForm '3


The problem with this is that VBA waits for me to close the form before
moving on to step 2. So, the complexmacro only starts loading after the Wait
message has been closed! I do not want to call (2) in the WaitMessageForm.
It would be ideal if VBA runs the Form in the background and proceeds to the
next statement. Any way of making this happen?

Thanks,
Vince

 

[Word Heretic]

G'day "Vince" <[email protected]>,

Forms have a modal property. Modal forms stay up whilst the macro runs
behind.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Vince reckoned:

 

[Vince]

Form.show VBModal
Form.show

both seem to have the same affect. The statements following tend to wait
till the Form is closed. So, are you saying that I should scrap the form and
put a message box before & after the complexmacro?

 

[Vince]

Got it,thanks! Set the modal property to false!
Thanks again
Vince