VBA: Status Bar Updating

August 14th, 2004 | Categories: VBA | Tags: , ,

You can update the status bar in Excel while a macro is running to display a custom message.

1. Place this code in a macro whenever you want to update the user with a custom status bar message:

Application.StatusBar = "I'm working Now!!!"

2. And at the end of your macro place this code to return the status bar back to Excel:

Application.StatusBar = FALSE

Leave a comment | Trackback
  1. techphets
    December 4th, 2008 at 16:28
    Reply | Quote | #1

    Excellent entry. Simple and helpful. Thank you.

  2. Zoltan Till
    February 10th, 2009 at 08:48
    Reply | Quote | #2

    Thanks,

    A little addition:
    Application.DisplayStatusBar = True
    ‘to makes sure that the statusbar is visible