Application.CalculationInterruptKey Property

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.

Visual Basic for Applications

Visual Basic for Applications
`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`

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

calculation calculation interrupt key calculationinterrupt calculationinterruptkey calculationinterruptkey property

Application.CalculationInterruptKey Property

Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations. Read/write.

See also: