status bar updates

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Status bar updates

Status bar updates

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Display Formulas Instead of Results in Excel 2010

By pressing Ctrl ~ once, Excel will display formulas rather than the results of the formulas. Press it again, and the results will appear again.

A much quicker and simpler way of displaying your formulas!

View all Excel hints and tips


Server loaded in 0.08 secs.