daauniversal.blogg.se

If your macro takes a bit of time to complete using the status bar will ensure that the user does not think that the macro has crashed or is not responding. If you switch the ScreenUpdating off to prevent the screen from flickering it is worth using the Status bar to keep the user informed about the current status of the macro. StatusBar messages are still displayed even when ScreenUpdating is turned off.Īt the end of the process you must change the StatusBar property to False so it can return to its normal status. This should definitely be used when you turn ScreenUpdating off and there is no sign of activity of the screen. This is an easy way to keep users informed of progress during a length macro.

Important! Use the StatusBar property to set messages, but use the DisplayStatusBar property to disable or enable the status bar altogether.The StatusBar property allows you to assign a text string to be displayed on the left of the statusbar. Application.DisplayStatusBar = FalseĪt the end of your code, restore Status Bar updating: Application.DisplayStatusBar = True To disable Status Bar updating while your code is running set the DisplayStatusBar property to false. This will increase the speed of your VBA code as Excel can skip processing what Status Bar message to display. Instead of displaying a message while your procedure runs, you can disable the Status Bar.

And at the end of your macro place this code to clear the status bar and return control back to Excel: Application.StatusBar = FALSE

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!!!"Ģ.

You can update the status bar with your own custom message in Excel while a macro is running, using the StatusBar property.ġ. However the StatusBar Property can also be adjusted using VBA, allowing you to display your own messages. At the bottom-left corner of Excel, you’ll find a Status Bar:Įxcel uses this status bar to communicate messages to you.