Programming Excel with VBA and .NET

ErrorChecking Members

The ErrorChecking object has the following members:

Application	BackgroundChecking
Creator	EmptyCellReferences
EvaluateToError	InconsistentFormula
IndicatorColorIndex	ListDataValidation
NumberAsText	OmittedCells
Parent	TextDate
UnlockedFormulaCells

Most of the ErrorChecking members are True/False properties that enable or disable specific error-checking options. The following code displays a list of the current error-checking settings in Excel:

Sub ShowErrorCheckingSettings(  )
    With Application.ErrorCheckingOptions
        Debug.Print .BackgroundChecking
        Debug.Print .EmptyCellReferences
        Debug.Print .EvaluateToError
        Debug.Print .InconsistentFormula
        Debug.Print .IndicatorColorIndex
        Debug.Print .ListDataValidation
        Debug.Print .NumberAsText
        Debug.Print .OmittedCells
        Debug.Print .TextDate
        Debug.Print .UnlockedFormulaCells
    End With
End Sub

These properties correspond to the settings on the Error Checking dialog box shown in Figure 7-5. To see the dialog, choose Tools → Error Checking → Options.