BackgroundChecking Property

Microsoft Excel Visual Basic

BackgroundChecking Property

       

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.BackgroundChecking

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

Remarks

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

Example

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
    Range("A1").Select
    ActiveCell.Formula = "=A2+A3"

End Sub