BackgroundChecking Property

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Alerts the user for all cells that violate enabled error checking rules. When this property is set to True (default), the AutoCorrect Options button appears next to all cells that violate enabled errors. False disables background checking for errors. Read/write Boolean.


expression   Required. An expression that returns one of the objects in the Applies To list.


Refer to the ErrorCheckingOptions object to view a list of its members that can be enabled.


In the following example, when the user selects cell A1 (which contains a formula referring to empty cells), the AutoCorrect Options button appears.

  Sub CheckBackground()

    ' Simulate an error by referring to empty cells.
    Application.ErrorCheckingOptions.BackgroundChecking = True
    ActiveCell.Formula = "=A2+A3"

End Sub