Application.ErrorCheckingOptions Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Sub CheckTextDate()

' Enable Microsoft Excel to identify dates written as text.
Application.<strong>ErrorCheckingOptions</strong>.TextDate = True

Range("A1").Formula = "'April 23, 00"



End Sub

See Also