|
SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY Phone: +61 421 551 254 Email: wakelinsolutionz@bigpond.com |
|
Use the status bar to let the user know what stage the macro is up to
You can use Excel's status bar (normally says "Ready") to tell the user what is happening during a macro. This is useful if the macro takes a while to run and the user may think that nothing is happening.
You must always set the status bar back to false at the end of the macro. This gives control back to Excel and sets the status bar to be "Ready".
If you stop a macro once it has started, the status bar may be left with your message. Once you restart Excel, the status bar will be set back to "Ready".
Sub MyProgram Application.StatusBar = "Working on part one of the macro" Your Code Application.StatusBar = "Working on part two of the macro" Your Code Application.StatusBar = False End Sub
|
||
|