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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Status Bar more complex 1
Problem: Cells show 0 despite formulas 2
Help With Input Box 3
Status Bar 2
Excel File; CanCheckOut <> True in SharePoint 1
Strange Problem with Formulas 1
Workbooks.OpenText Error 1004 3

Top