Screen Updating Application Property in VBA is used to turn ON/OFF screen updating.
If we set Screen Updating property to TRUE then it turns on the screen updating else turn off the screen updating. In the above syntax Application represents object and Screen Updating is the Property of Application object.
When we set Screen Updating property of an application object to false then it will speed up the macro. Please find the below example for Screen Updating Property of an application object in excel VBA.
Explanation: In the above example, it will display numbers from 1 to 100 in the first column on Sheet1.
This can mean that what should take a matter of 1 to 3 seconds, often takes a lot longer.
A VBA add-in to quickly insert any of the sample code found on our site directly into the Visual Basic Editor, save your own frequently used code, and more!By setting Screen Updating to False at the Start of the macro, you will not only stop the constant screen flickering associated with recorded macro, but also greatly speed up the execution of the macro.The reason it speeds up code is because Excel no longer needs to repaint the screen whenever it encounters such commands as Select, Activate, Large Scroll, Small Scroll and many others. Screen Updating=False should be placed at the Start of your macro like shown below Note how we have set the Screen Updating back to True on completion.Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell. Range For repeat = 1 To 30 For Each cell In r cell. Value Mod 2 = 0) Then ' if i is even, color the cell white cell. I always assumed it was just used so that it didn't scare end users into thinking their PC was about to crash.