Display Message to User While Application Runs?

[jasonyantiss]

Hello,

Is there a way to Display a message to the user while an application is running?

For example, while a macro is doing it's thing, at it takes some time for the macro to run, instead of showing everything that's going on, could a message be displayed that says "Your Query is Running" ? (just as an example)

Thanks very much for any help!

 

[hiker95]

jasonyantiss,

You could use Excel's Status Bar.

  '***** Near the beginning of your code. *****
  Application.StatusBar = "Your Query is Running"

  
  'The bulk of your macro code
  

  '***** Near the end of your code. *****
  Application.StatusBar = ""

 

[VoG]

At the end it is better to use

Application.StatusBar = False

to allow Excel to display information in the status bar.

 

[hiker95]

Peter,

Thank you again.