CalculationInterruptKey Property

Microsoft Excel Visual Basic

Show All

CalculationInterruptKey Property

       

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

XlCalculationInterruptKey can be one of these XlCalculationInterruptKey constants.
xlAnyKey
xlEscKey
xlNoKey

expression.CalculationInterruptKey

expression   Required. An expression that returns one of the objects in the Applies To list.

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