Excel vba status bar screenupdating

Rated 4.70/5 based on 896 customer reviews

I am running a lot of code for creating some reports.

To see how far the creation of reports has proceeded, I want to show a loading bar on my control sheet.

I was able to solve the issue to my liking by using a workaround this 'which window is on top' problem.

Cursor = xl Default This solved my flicker problem, but I didn't like how the excel application disappeared completely then suddenly reappeared for the user.

Given that I have some code that is surrounded by Application. Screen Updating = False' The screen does not flicker when i execute this macro.

Screen Updating = false and = true, to hide what the macro is doing from the user, is there any way that I can display a progress bar. SU = true then all changes will be shown to the user and I'd rather not go down that route (yet! The code lends itself very well as there are 200 queries and each of these could represent 0.5% of the bar Any ideas ??? My question is, is it advisable to also include the line; 'Application. Thanks Hi B_2, I would include the =True line as a matter of course as it makes it clear to anyone reading the code what is happening.

The problem I have now shows in updating these loading bars.

When running my code, different macros are executed.

excel vba status bar screenupdating-43

excel vba status bar screenupdating-41

I've got screenupdating turned on on, status Bar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000 and then stops.

Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. I wanted to leave a comment but I am not allowed to do so.

Without a code sample it is very dificult to understand your problem (please see https://stackoverflow.com/help/how-to-ask and edit your question appropriately.

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.

Leave a Reply