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: