CalculationState Property
TOC
Collapse the table of content
Expand the table of content

Application.CalculationState Property

Office 2007
Returns an XlCalculationState constant that indicates the calculation state of the application, for any calculations that are being performed in Microsoft Excel. Read-only.

Syntax

expression.CalculationState

expression   A variable that represents an Application object.

Example

In this example, Microsoft Excel checks to see if any calculations are being performed. If no calculations are being performed, a message displays the calculation state as "Done". Otherwise, a message displays the calculation state as "Not Done".

Visual Basic for Applications
Sub StillCalculating()

    If Application.CalculationState = xlDone Then
        MsgBox "Done"
    Else
        MsgBox "Not Done"
    End If

End Sub



Show:
© 2016 Microsoft