ScreenUpdating Application Property in VBA is used to turn ON/OFF screen updating. If we set ScreenUpdating property to TRUE then it turns on the screen updating else turn off the screen updating. When we set ScreenUpdating property of an application object to false then it will speed up the macro. It’s one of the optimizing technic.

Excel VBA ScreenUpdating Application Property

VBA ScreenUpdating Application Property – Syntax

Here syntax for ScreenUpdating Property of application object in VBA.

Application. ScreenUpdating

Where ScreenUpdating as Boolean datatype.
In the above syntax Application represents object and ScreenUpdating is the Property of Application object.

VBA ScreenUpdating Application Property: Example 1

Please find the below example for ScreenUpdating Property of an application object in excel VBA.

Sub Appl_ScreenUpdating1()    
‘Variable declaration   
 Dim I As Integer
    For I = 1 To 100
        Sheets("Sheet1").Cells(I, 1) = I
    Next    
End Sub

Explanation: In the above example, it will display numbers from 1 to 100 in the first column on Sheet1. We can notice the screen updating while updating Sheet1.

VBA ScreenUpdating Application Property: Example 1

Please find the below example for ScreenUpdating Property of application object in excel VBA.

Sub Appl_ScreenUpdating2()
    Application.ScreenUpdating = False
    
    Dim I As Integer
    For I = 1 To 100
        Sheets("Sheet1").Cells(I, 1) = I
    Next
    
    Application.ScreenUpdating = True
End Sub

Explanation: In the above example, it will display numbers from 1 to 100 in the first column on Sheet1. We can observe that there is no screen updating till running the macro. Don’t forget to reset the ScreenUpdating valsue as TRUE at the end of the macro.

VBA ScreenUpdating Application Property – Instructions

Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: Now press F5 to execute the code and observe when ScreenUpdating is ON and OFF.

Premium Project Management Templates

120+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

Advanced Project Planning Templates

Excel Templates

VIEW DETAILS

120+ Project Management Templates Pack

Excel | PowerPoint | Word

VIEW DETAILS

ULTIMATE RESOURCE MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

50+ Essential Project Management Templates

Excel | PowerPoint | Word

VIEW DETAILS

Project Portfolio Management Templates

Excel | PowerPoint Templates

VIEW DETAILS

50+ Excel Project Management Templates

Excel Templates

VIEW DETAILS

Share This Story, Choose Your Platform!

Leave A Comment