Application.CalculationInterruptKey Property (Excel)
Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations. Read/write.
Syntax
expression .CalculationInterruptKey
expression A variable that represents an Application object.
Example
In this example, Microsoft Excel determines the setting for the calculation interrupt key and notifies the user.
Sub CheckInterruptKey()
' Determine the calculation interrupt key and notify the user.
Select Case Application.CalculationInterruptKey
Case xlAnyKey
MsgBox "The calcuation interrupt key is set to any key."
Case xlEscKey
MsgBox "The calcuation interrupt key is set to 'Escape'"
Case xlNoKey
MsgBox "The calcuation interrupt key is set to no key."
End Select
End Sub