Archive of Mr Excel Message Board
Back to Excel VBA archive index
Back to archive home
"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
| Check out our Excel VBA Resources
|
 |
 |
 |
 |
 |
Re: "Please Wait" message box with progress indicator
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
Re: "Please Wait" message box with progress indicator
Posted by Barrie Davidson on June 21, 2001 1:42 PM
Have a look at
http://j-walk.com/ss/excel/tips/tip34.htm
Chris, you can speed up your code if you use:
Posted by Joe Was on June 22, 2001 2:19 PM
Application.ScreenUpdating = False
At the begining of your code and
Application.ScreenUpdating = True
at the end of your code!
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.