CalculationInterruptKey Property
TOC
Collapse the table of content
Expand the table of content

Application.CalculationInterruptKey Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .CalculationInterruptKey

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 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
Show:
© 2016 Microsoft