Excel.Application.CalculationInterruptKey.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.CalculationInterruptKey property (Excel)	vbaxl10.chm133266	vbaxl10.chm133266	Excel.Application.CalculationInterruptKey	1187c122-0498-a82c-5479-1595c7f06448	04/04/2019	medium

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 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

[!includeSupport and feedback]