Excel vba status bar screenupdating

Posted by / 07-Jun-2019 15:50

Excel vba status bar screenupdating

The screen unfreezes apparently when VBA code copies a preformatted worksheet from the macro workbook into a new workbook, although other circumstances must trigger it as well.

I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.

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.

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.

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.

Here are some ideas: - Check if your code calls for code in a different procedure, maybe the Application.

Screen Updating is turned on outside of the procedure.

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.

excel vba status bar screenupdating-14excel vba status bar screenupdating-16excel vba status bar screenupdating-78

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

One thought on “excel vba status bar screenupdating”