Application.CalculationState Property

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".

  Sub StillCalculating()
If Application.<strong>CalculationState</strong> = xlDone Then
    MsgBox "Done"
Else
    MsgBox "Not Done"
End If

End Sub

See Also

• Application Object
• Application Object Members