msg box while operation is running.

T

Tod

The message box will halt your code. If you want some
notification while a macro is running, you could use the
Status Bar or (my favorite) display a message box after
the code has run.

The Status Bar idea would work like this:

oldSB = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Wait as I get jiggy with it..."
'Code
Application.StatusBar = False
Application.DisplayStatusBar = oldSB

tod
 
K

Keivn Green

OOO I like that. Cool!

Thanks

Tod said:
The message box will halt your code. If you want some
notification while a macro is running, you could use the
Status Bar or (my favorite) display a message box after
the code has run.

The Status Bar idea would work like this:

oldSB = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Wait as I get jiggy with it..."
'Code
Application.StatusBar = False
Application.DisplayStatusBar = oldSB

tod
Click to expand...
 
Top