ScreenUpdating Property of Application Object VBA

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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.

LIMITED TIME OFFER

Leave A Comment


Related pages


combobox macroexcel vba applicationgantt project excel templateexcel data entry form template excel 2007excel vba ado recordsetunprotect excel workbook onlineconstruction cost template excelvba create databaseunlocking password protected excel filehow to remove blank lines in excelexcel chrexcel consolidate worksheets into oneexcel vlookup formula exampleworksheet function vbaquery table vbahyperlink addresshow to lock an excel file 2007hide and unhide columnsmerge a cell in excellearn vba for excelhow to lock spreadsheetdelete vbaexcel macro dimexcel how to remove blank rowsexcel copy sheet to another workbookhow to open xlsx files in excel 2003excel vba cells offsetsample macros in excelexcel vba sql query access databasevba merge cellsswot template excelview developer tab in excelprompt vbaexcel column auto widthvba in excel 2007 tutorialmicrosoft estimate templateexcel vba formhow to add option button in excelhow to create userform in excel vbaexcel vba create new workbookpassword protect a spreadsheetexcel to xml conversiondisplay vbaexcel delete row vbamerge and center selected cellshow to remove blank columns in excelvba workbooks openbasic vba commandsmacros excel 2007excel vba offsetexcel delete hidden rowsdeveloper tool in excel 2007excel dashboard widgetsexcel shortcut insert rowcell height excelproject dashboard templatesunhide columns in excelprogress bar vba excel 2010vba skillsactivesheet rangeadvanced pivot table excel 2010 tutorialvba font colourexcel macros tutorial pdfwhat is the developer tab in wordapplication.worksheetfunction.vlookuparray in vba exceldefine pivot table excelsas eg tutorialbest excel vba bookhow to autofit in excel 2013cool excel vba coderemove blank lines in excelvba converter packmicrosoft office planner templatefix excel rowmultiple if function excel 2010vba redim preserve array