MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to write to the Status Bar in Excel97-VBA


Posted by René on October 22, 2001 7:13 AM

I've been hanging around on most known VBA sites without any results to my question :

How can I write comments to the Excel97-StatusBar while a macro is running, just to inform the user of what is happening during execution. Because it's a rather long execution the user might become impatient if there are no communications from the macro.


Posted by Juan Pablo on October 22, 2001 7:35 AM

Use

Application.StatusBar = "Working, don't kill me yet"

and at the end of the macro (Or whenever you want) put

Application.StatusBar = False

Juan Pablo

Posted by Mark O'Brien on October 22, 2001 7:43 AM

Change text

Application.StatusBar = "Please Wait...Application is running."

' ****Your code****

' Reset statusbar when you're finished

Application.StatusBar = False