Calculation Property of Application Object VBA

Calculation Application Property in VBA represents the calculation mode and returns XlCalculation value. Please find more details about XlCalculation Enumeration values at the end of the chapter. Please find more information about Calculation property in the following chapter.

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 Calculation Application Property – Syntax

Here syntax for Calculation Property of application object in VBA.

Application. Calculation

Where Calculation as XlCalculation. Please find more details about XlCalculation Enumeration values in the end of the chapter.
In the above syntax Application represents object and Calculation is the Property of Application object.

VBA Calculation Application Property: Example 1

Please find the below example for Calculation Property of application object in excel VBA. When XlCalculation value is xlCalculationAutomatic, It Controls the Excel recalculation.

 
Sub Window_xlCalculationAutomatic()
Application.Calculation = xlCalculationAutomatic
End Sub

VBA Calculation Application Property: Example 2

Please find the below example for Calculation Property of application object in excel VBA. When XlCalculation value is xlCalculationManual, the user requests for the calculation.

Sub Window_xlCalculationManual()
Application.Calculation = xlCalculationManual
End Sub

VBA Calculation Application Property: Example 3

Please find the below example for Calculation Property of application object in excel VBA. When XlCalculation value is xlCalculationSemiautomatic, It Controls the Excel recalculation but ignores the changes in tables.

Sub Window_xlCalculationSemiautomatic()
Application.Calculation = xlCalculationSemiautomatic
End Sub

VBA Calculation 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 Window.
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.
Step 6: Run the above examples in debug (F8) mode for better understand.

VBA XlCalculation Enumaration Values

Please find the below VBA XlCalculation Enumaration Values, Name and their description.

Excel Name Value Description
xlCalculationAutomatic -4105 Controls Excel recalculation
xlCalculationManual -4135 User requests for the calculation
xlCalculationSemiautomatic 2 Controls the Excel recalculation but ignores the changes in tables
LIMITED TIME OFFER

Leave A Comment


Related pages


combine multiple cells in exceland condition in vbaexcel formula for colour of cellexample of countif in excelmerge excel files macrovba insertnested if then excelvba create folderexcel formula to find color of cellvisual basic sample codes for beginnersexcel formula shortcuthow to get developer tab in excel 2013open and activate workbook vbaexcel workbook password crackerexcel vba copy workbookvb interview questionsxlpastevaluesvba connection stringduplicate formula excelvba case statementsimple example of vlookup in excelhow to highlight duplicate values in excelexcel remove duplicate linesbusiness analyst interview questions and answers pdfhow to write vba code in accesschange xlsx to csvmis executive interview questions and answers pdfaccess vba do while loophow to unlock formulas in excelexcel password templateproject costing excel templateexcel vba database querycomment excel vbahow do i autofit in excelsumif exampleexcel formulas tutorial with examplesmicrosoft excel chart wizardvba sumifexcel iferror vlookupplanning xls templateshow to delete multiple records in sqlfile exists vbavlook up tutorialvb color codesinterview worksheetsexcel vba range &vba coding exampleschart tools layout tab excel 2013how to calculate the difference between two dates in excelmsgbox vba yes novlookup for beginnersvba columnwidthunprotect excel macrounprotect an excel sheet without passwordnested if in excel 2010dynamic pivot table in sql server 2008unlock vba projectdebug.print vbacell interior color vbaexcel task tracking templateexcel vba activate workbookexcel formula to check for duplicatesproject management excel dashboardproject management sheet excelcombobox vba codeconnect excel to sql databaseexcel formula correctorexcel remove duplicates from columnpassword protect vba codeexcel remove hyperlinksvba custom message boxinsert a new worksheet in excelsql test papers with answersquery excel with sqlhow to create pivot table in excel 2007 with exampleexcel vba sleepmicrosoft excel remove duplicatesuseful vb scripts for windows 7how to insert macros in excel