ErrorCheckingOptions.BackgroundChecking Property

  • Article
Excel Developer Reference

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.

Syntax

expression.BackgroundChecking

expression   A variable that represents an ErrorCheckingOptions object.

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.

Visual Basic for Applications 
  Sub CheckBackground()

' Simulate an error by referring to empty cells.
Application.ErrorCheckingOptions.<strong>BackgroundChecking</strong> = True
Range("A1").Select
ActiveCell.Formula = "=A2/A3"



End Sub

See Also