BackgroundChecking 属性 (Excel) ErrorCheckingOptionsErrorCheckingOptions.BackgroundChecking property (Excel)

警告用户并指出违背可用错误检查规则的所有单元格。Alerts the user for all cells that violate enabled error-checking rules. 如果该属性设置为 True (默认值),则在违背启用错误的所有单元格旁边将出现 “自动更正选项” 按钮。When this property is set to True (default), the AutoCorrect Options button appears next to all cells that violate enabled errors. 如果为 False,则禁用背景错误检查。False disables background checking for errors. 读取/写入 BooleanRead/write Boolean.

语法Syntax

表达式BackgroundCheckingexpression.BackgroundChecking

_表达式_一个代表**ErrorCheckingOptions** 对象的变量。expression A variable that represents an ErrorCheckingOptions object.

说明Remarks

请参阅ErrorCheckingOptions对象, 以查看可启用的成员列表。Refer to the ErrorCheckingOptions object to view a list of its members that can be enabled.

示例Example

在下例中,当用户选择单元格 A1(该单元格包含引用空单元格的公式)时,将出现 “自动更正选项” 按钮。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

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.