Excel vba status bar not updating

Excel vba status bar not updating

The solution is to make sure the status bar is turned on before you try to display a message. If you want to erase the message on the status bar, there are two ways you can do it. Maybe a wait command or something would do it. You can control the display of the status bar by using the Application.

The program works as intended, it is just horribly slow and the status bar doesn't update consistently, but it could be a bug in Vista display or something outside of excel's control. Before blinking your eyes the macro will be terminated and you won't need a statusbar at all. StatusBar property erases whatever you wrote on the status bar before and restores the default status bar text. In between, the status bar is turned on and a message is displayed and later erased. To be clear the status bar sometimes does update at the beginning, or if I use step thru mode it always does.

StatusBar property erases whatever you wrote

Seems to only happen in Excel and not in previous version. ExcelTips is your source for cost-effective Microsoft Excel training. Get tips like this every week in ExcelTips, a free productivity newsletter. It is likely that it has something to do with the lack of actual data in the sheet I sent you so that the writing is way less than in reality. Making changes to this list is not easy.

When this is done, one of the most important things you can do is provide feedback to the user so they don't think their system has gone out to lunch. This message remains there until another message is written to the status bar, either by your macro or by Excel. This same variable is used in the last line to reset the status bar condition to its original state. Excel can be customized, by the user, so that the status bar is turned off.

Using the status bar is all fine and good, as long as the status bar is turned on. Discover More Self-Aware Macros Sometimes it may be helpful for a macro to know exactly where it is being executed.

The program works as intended itBefore blinking your eyes the macro