Thread: "Ready"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default "Ready"

Here is how to set the status bar...
Application.StatusBar = "Test"
And here is how to reset it...
Application.StatusBar = ""

It is usually a good idea to have an error handler when you are using this
code to reset the value if the code crashes...

HTH

"Arturo" wrote:

How do I alter the bottom left corner of Excel which usually displays Ready
or Calculating Cells, to say what I choose while code is running, and then
reset it when done?

Appreciatively
Arturo