Application.ErrorCheckingOptions Property

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 

See also:

• Application Object
• Application Object Members