REAL-TIME

VBA Projects

Full Access with Source Code
  • Designed and Developed by PNRao

  • Full Access with VBA Source Code

  • Well Commented Codes Lines

  • Creative and Professional Design

Effortlessly
Manage Your Projects

120+ Project Management Templates

Seamlessly manage your projects with our powerful & multi-purpose templates for project management.

120+ PM Templates Includes:
  • 50+ Excel Templates

  • 50+ PowerPoint Templates

  • 25+ Word Templates

Share Post

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.

Excel VBA Calculation Application Property Object

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 Enumeration Values

Please find the below VBA XlCalculation Enumeration 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
Effortlessly Manage Your Projects and Resources
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.

Save Up to 85% LIMITED TIME OFFER
Project Management Templates

All-in-One Pack
120+ Project Management Templates

Essential Pack
50+ PM Templates

Excel Pack
50+ Excel PM Templates

PowerPoint Pack
50+ Excel PM Templates

MS Word Pack
25+ Word PM Templates

Ultimate Project
Management Template
Ultimate Resource
Management Template
Project Portfolio
Management Templates
Last Updated: March 2, 2023

Leave A Comment