다음을 통해 공유

Application.ErrorCheckingOptions Property (Excel)

  • 아티클

Returns an ErrorCheckingOptions object, which represents the error checking options for an application.

Syntax

식 .ErrorCheckingOptions

식 A variable that represents an Application object.

Example

In this example, the TextDate property is used in conjunction with the ErrorCheckingOptions property. When the user selects a cell containing a two-digit year in the date, the AutoCorrect Options button appears.

Sub CheckTextDate() 
 
 ' Enable Microsoft Excel to identify dates written as text. 
 Application.ErrorCheckingOptions.TextDate = True 
 
 Range("A1").Formula = "'April 23, 00" 
 
End Sub

참고 항목

개념

Application Object

Application Object Members