Vba excel status bar not updating

I admit that allowing Excel to update the screen each time your macro makes a change, helps during development, but it slows down the code a lot.It is best to set the Screen Updating and Enable Events properties of the Application object to at the outset.

We may also choose to use the width property of a control and resize it as the code progresses, to display a progress bar of sorts.Excel is versatile by itself and VBA makes it even better by allowing us to do our own thing.Most of us use VBA to automate tasks of varying complexity – some macros are executed in a flash, but others take hours to run.Next loop, he always uses the status bar to indicate progress.Typically, he'll have a message displayed there such as "Processing row X of Y." When "Y" is a large value (the top end of the For...