Expand Minimize

Application.ErrorCheckingOptions Property (Excel)

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

expression .ErrorCheckingOptions

expression A variable that represents an Application object.

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 

Show:
© 2014 Microsoft