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


export excel macrosexcel exit macrohow to learn excel vba programmingconditional logic excelsql equality operatorsunprotect workbook excel 2007how to make macros in excel 2007hide worksheets in excelvba macros tutorialshow to lock spreadsheetall shortcut keys of excel 2007find duplicates in excel columns3d pie chart excelautomation vbaexcel autofit column widthmacro excel programmingexcel sorting macroexcel dashboard pluginvba remove duplicatessql dmlinserting a macro in excelmerge excel tabsinsert blank rows in excelvba copy cellshow to calculate difference between two dates in excelremove duplicates in excel 2007excel instrvba application.statusbarcreate command button in excelvb6 combobox datasourceteradata macro exampleformula vlookup in excelexcel formula sort alphabeticallyhow to unhide rows and columns in excel 2010excel tutorial intermediateadding columns excelunhiding column amicrosoft office estimate templatedbms interview questions and answers for freshers pdfvba sheet1sql aptitude questions with answers pdfvba rtrimmacro in excel 2007 tutorialhow to de dupe in excelmacros for excel 2007excel insert shortcutsave workbook vbavba if statement examplein excel vlookup formula exampleworksheetfunction.vlookupapplication.workbooks.openexcel vba applicationsdisplay alert vbaeasy vlookup stepshow do i merge columns in excelfor loop vba exceldata analysis add in excel 2007how to do pivot table in excelpivots excelwhat is hlookup in excel with examplems excel merge cellsjob tracking excel templatepivot table meaningdefine excel macrohow to merge cells in excel with multiple datavba code for loopdata mining add instotal number of rows and columns in excel 2007excel unhide workbookmonthly schedule excel templateexcel consolidate columnshow to create macros in excelexcel vba select sheetsql interview questions with answers pdf3d pie chart in excelxl to xml converterformula for vlookuppowerpoint macro examples