Well, when you run VBA code in Excel, you will notice that the screen flickerseach time an action is performed.Lets take a simple example: If you run this, each time the cell below is selected, you will see that the screen has updated.
Also by using a class, you can set it up to handle initializing and releasing the Status Bar automatically.
Everything works as expected when using one single macro. I hava a Worksheet Calculate event that I have also set updaing to false then True at the end.
Anyone know how to ensure no updating happens even if macro triggers additional macros to run? They do BUT the running of the second macro seems to start with updating = true. Lets assume for a moment that it is the setting back to true at the end of the secondary macro that is causing the issue, should I apply an updating check at point(s) when the macro returns to the originally called code? NEW QUESTION - If I do not set updating back to True how can that negatively affect the spreadsheet?
This is fine as long as your macro is small, but if it is big, Screen Updating can take a long time, and turning it off can make VBA code run faster.
Let’s prove that: This code for me takes 0.64 seconds to run Now, lets turn off Screen Updating and see the difference: 0.64 seconds vs 0.078 seconds The faster VBA code runs 8 times the speed of the slow code.