
Tips.Net > WordTips Home > Macros > VBA Examples > Displaying a Message in the Status Bar
Summary: A great place for your macro to display status information is, well, in the status bar. Displaying the information is easy, as this tip points out. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)
When you are creating VBA macros, you can place a message on the status bar by using (oddly enough) the StatusBar property. For instance, the statement
StatusBar = "I'm working as fast as I can..."
will print the message within the quote marks on the status bar. If you use the StatusBar property, you can keep users informed about what your macro is doing. (After all, it's best not to leave them wondering.) If you want to "turn off" what is displayed in the status bar, you can do so by using the following statement:
StatusBar = ""
Tip #723 applies to Microsoft Word versions: 97 2000 2002 2003 2007
Step Up and Take Control! Subscribers to WordTips know just how valuable a resource it is. WordTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on WordTips archives and e-books.
Check out WordTips Premium today!
Thousands of WordTips, available for immediate download. Have all the Microsoft Word info you need, right at your fingertips. (more information...)
Ask a Word Question
Make a Comment
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips