VBA – Display Status Bar Message

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on July 19, 2021

At the bottom-left corner of Excel, you’ll find a Status Bar:

vba update status bar

Excel uses this status bar to communicate messages to you. However the StatusBar Property can also be adjusted using VBA, allowing you to display your own messages.

Custom Status Bar Message

You can update the status bar with your own custom message in Excel while a macro is running, using the StatusBar property.

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 clear the status bar and return control back to Excel:

Application.StatusBar = FALSE

tiphacks2

Disable Status Bar Updating

Instead of displaying a message while your procedure runs, you can disable the Status Bar.  This will increase the speed of your VBA code as Excel can skip processing what Status Bar message to display.

To disable Status Bar updating while your code is running set the DisplayStatusBar property to false.

Application.DisplayStatusBar = False

At the end of your code, restore Status Bar updating:

Application.DisplayStatusBar = True

Important! Use the StatusBar property to set messages, but use the DisplayStatusBar property to disable or enable the status bar altogether.

Speed Up VBA Code

For optimal processing speed try using this code:

sub RunFast()

Application.ScreenUpdating = False
Application.DisplayStatusBar = False
Application.EnableEvents = False
ActiveSheet.DisplayPageBreaks = False
Application.Calculation = xlCalculationManual

'Your Code Here

Application.ScreenUpdating = True
Application.DisplayStatusBar = True
Application.EnableEvents = True
ActiveSheet.DisplayPageBreaks = True
Application.Calculation = xlCalculationAutomatic
end sub

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!

alt text

 

Learn More!


<<Return to VBA Examples

vba-free-addin

VBA Code Examples Add-in

Easily access all of the code examples found on our site.

Simply navigate to the menu, click, and the code will be inserted directly into your module. .xlam add-in.

(No installation required!)

Free Download

Return to VBA Code Examples