Application.ErrorCheckingOptions Property (Excel)
Returns an ErrorCheckingOptions object, which represents the error checking options for an application.
Syntax
expression .ErrorCheckingOptions
expression 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