98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Status bar updates
Status bar updates
Resolved · Low Priority · Version 2007
Irene has attended:
Excel VBA Intro Intermediate course
Status bar updates
How can we state what the macro is doing in the status bar?
RE: Status bar updates
Hi Irene, thanks for your query. The following line of code will allow you to display text on the Status bar:
Application.StatusBar = "Macro 1 is now working..."
Hope this helps,
Anthony
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Display Formulas Instead of Results in Excel 2010By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again. |