Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / December 2004

Tip: Looking for answers? Try searching our database.

Background execution of Form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vince - 14 Dec 2004 07:11 GMT
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 - 14 Dec 2004 08:15 GMT
G'day "Vince" <sdsad@fsd.com>,

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:

>Hi all,
>
[quoted text clipped - 17 lines]
>Thanks,
>Vince
Vince - 14 Dec 2004 08:15 GMT
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?

> G'day "Vince" <sdsad@fsd.com>,
>
[quoted text clipped - 29 lines]
> >Thanks,
> >Vince
Vince - 14 Dec 2004 08:29 GMT
Got it,thanks! Set the modal property to false!
Thanks again
> Form.show VBModal
> Form.show
[quoted text clipped - 40 lines]
> > >Thanks,
> > >Vince

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.