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?
.
|