Application.CalculationState Property

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.CalculationState = xlDone Then MsgBox "Done" Else MsgBox "Not Done" End If End Sub

See also:

• Application Object
• Application Object Members