ErrorCheckingOptions object (Excel)
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.
After 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.
- BackgroundChecking
- EmptyCellReferences
- EvaluateToError
- InconsistentFormula
- IndicatorColorIndex
- NumberAsText
- OmittedCells
- TextDate
- UnlockedFormulaCells
Example
The following example uses the TextDate property to enable error checking for two-digit-year text dates, and then notifies the user.
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
Properties
- Application
- BackgroundChecking
- Creator
- EmptyCellReferences
- EvaluateToError
- InconsistentFormula
- InconsistentTableFormula
- IndicatorColorIndex
- ListDataValidation
- NumberAsText
- OmittedCells
- Parent
- TextDate
- UnlockedFormulaCells
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.