Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ErrorCheckingOptions Object
Collapse the table of content
Expand the table of content

ErrorCheckingOptions Object

Office 2007
Represents the error-checking options for an application.

Remarks

Use the ErrorCheckingOptions property of the Application object to return an ErrorCheckingOptions object.

Reference the Item property of the Errors object to view a list of index values associated with error-checking options.

Once an ErrorCheckingOptions object is returned, you can use the following properties, which are members of the ErrorCheckingOptions object, to set or return error checking options.

Example

The following example uses the TextDate property to enable error checking for two-digit-year text dates and notifies the user.

Visual Basic for Applications
Sub CheckTextDates()

    Dim rngFormula As Range
    Set rngFormula = Application.Range("A1")

    Range("A1").Formula = "'April 23, 00"
    Application.ErrorCheckingOptions.TextDate = True

    ' Perform check to see if 2 digit year TextDate check is on.
    If rngFormula.Errors.Item(xlTextDate).Value = True Then
        MsgBox "The text date error checking feature is enabled."
    Else
        MsgBox "The text date error checking feature is not on."
    End If

End Sub



Community Additions

ADD
Show:
© 2015 Microsoft