Msgbox auto close

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Msgbox auto close

Post by Leesha »

Hi,
I have a report that is quite lengthy to run often times leaving the user wondering if it stopped. I put in msgbox's when throughout the process so they are aware of what is going on. This has helped however they are required to click the button to continue the process. Is there a way to have the msgbox show and stay on the screen while the code runs, then in code close the msgbox? I've done this with popup forms by that is so much more cumbersome to build.
Thanks!
Leesha

User avatar
HansV
Administrator
Posts: 78415
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Msgbox auto close

Post by HansV »

No. All code execution is halted while the message box is displayed, so you cannot use code to close the message box. I'm afraid you'll have to use popup forms...
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Msgbox auto close

Post by Leesha »

Ok Thanks!
Leesha