ErrorCheckingOptions.BackgroundChecking 屬性 (Excel)ErrorCheckingOptions.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.