Writing Excel Macros with VBA, 2nd Edition

Name

ErrorCheckingOptions Object

Synopsis

                  Path: Application - ErrorCheckingOptions

Object	Properties
ErrorCheckingOptions	BackgroundChecking( ) As Boolean EmptyCellReferences( ) As Boolean EvaluateToError( ) As Boolean InconsistentFormula( ) As Boolean IndicatorColorIndex( ) As XlColorIndex NumberAsText( ) As Boolean OmittedCells( ) As Boolean TextDate( ) As Boolean UnlockedFormulaCells( ) As Boolean

This object corresponds to the Error Checking tab under the Excel Options dialog box. The ErrorCheckingOptions object’s properties correspond to the check boxes in the aforementioned dialog box tab, as shown in Figure G-1.

Figure G-1. The Error Checking tab

For instance, when the Boolean TextDate property of the ErrorCheckingOptions object is set to True (corresponding to checking the check box labeled “Text date with 2 digit years”), Excel will display an AutoCorrect options button next to text cells that express the year as a two-digit value (rather than a four-digit value), for example Jan 1, 01.

The Errors collection object holds Error objects. The Errors object has the following members:

Properties

• Item(Index As Variant) As Error