bottom
Great WordTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > WordTips Home > Macros > VBA Examples > Displaying a Message in the Status Bar

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!

Helpful Links

Ask a Word Question
Make a Comment

Tips.Net Home
Vital News Home

WordTips FAQ
WordTips Premium

Learn Access Now

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

Advertise on the
WordTips Site

 

Great Info!

Get tips like this every week in WordTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)