Vba status bar not updating

Rated 4.94/5 based on 775 customer reviews

Next, you can drag a frame control on the Userform.

You can do this by clicking on Frame from the Toolbox.

This way, you can let the user know that a macro is still running.

Situation: The macro we are going to create fills Range("A1: E20") with random numbers.

vba status bar not updating-90

Note that at the start of the code I have the following Application.

It seems like the pane needs to be refreshed, but I don't see a method that does that. Do Events, the STA thread probably don't have time to consume events.

An other way would be to create a background worker thread that does your work, that would free the STA thread to process the event loop.

button to visit the description and screenshots of the tool on the website.

Below we will look at a program in Excel VBA that creates a progress indicator. If the Project Explorer is not visible, click View, Project Explorer. Right mouse click on the label control, and then click on Properties.

Leave a Reply