Application.CalculationInterruptKey property (Excel)
Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations. Read/write.
expression A variable that represents an Application object.
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 calculation interrupt key is set to any key." Case xlEscKey MsgBox "The calculation interrupt key is set to 'Escape'" Case xlNoKey MsgBox "The calculation interrupt key is set to no key." End Select End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.