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