MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Please Wait" message box with progress indicator


Posted by Chris Rock on June 21, 2001 1:35 PM

I have a macro that takes a good 45 seconds to run, and I'd like to throw up a message box for the user that says "Please wait while report is generated" or something like that while the macro is running.

It would be REALLY NICE if the "Please Wait" box had a progress indicator bar...one that fills in as the macro finshes. Is this possible?

Thanks in advance!

Chris Rock


Posted by Ben O. on June 21, 2001 1:38 PM

You can use Application.StatusBar = "Please Wait" to display that message in the status bar.

Just remember to use Application.Statusbar = False at the end of your macro or that message won't go away.

-Ben

Posted by Barrie Davidson on June 21, 2001 1:42 PM

Have a look at
http://j-walk.com/ss/excel/tips/tip34.htm

Posted by Joe Was on June 22, 2001 2:19 PM

Chris, you can speed up your code if you use:

Application.ScreenUpdating = False

At the begining of your code and

Application.ScreenUpdating = True

at the end of your code!