msg box while operation is running.
 

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
-----Original Message-----
Is there a way to make a message box come up only while
a macro is running
and then have it go away once the procedure is done?
.

msg box while operation is running.
 

OOO I like that. Cool!

Thanks

"Tod" wrote:

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
-----Original Message-----
Is there a way to make a message box come up only while
a macro is running
and then have it go away once the procedure is done?
.