VBA – Status Bar Updating

Associated Files Download Links


Custom Status Bar Message

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

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

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

tiphacks2

Disable Status Bar Updating

To speed up your code, you can disable Status Bar updating while your code is running:

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

Speed Up VBA Code

For optimal processing speed try using this code:

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

Did you find this VBA tutorial useful? Then share it with your friends and colleagues:

You may also like some of this related content...

Page Break Preview Mode To place Sheet1 in Page Break Preview View from code: Sheet1.Activate
Whenever you update a cell, Excel goes through a process to recalculate the workbook. When
As cool as it looks watching your macro manipulate the screen, you can help it
You can toggle scrollbars On or Off using a macro: Turn On Scrollbars Sub TurnOnScroll()
If your template design requires making Excel look less like Excel, you might want to
Ads