ErrorCheckingOptions Object Members

  • Article
Excel Developer Reference

Represents the error-checking options for an application.

Properties

  Name Description
Bb242239.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242239.properties(en-us,office.12).gif BackgroundChecking 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.
Bb242239.properties(en-us,office.12).gif EmptyCellReferences When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells containing formulas that refer to empty cells. False disables empty cell reference checking. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif EvaluateToError When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells that contain formulas evaluating to an error. False disables error checking for cells that evaluate to an error value. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif InconsistentFormula When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region. False disables the inconsistent formula check. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif InconsistentTableFormula Read/write
Bb242239.properties(en-us,office.12).gif IndicatorColorIndex Returns or sets the color of the indicator for error checking options. Read/write XlColorIndex.
Bb242239.properties(en-us,office.12).gif ListDataValidation A Boolean value that is True if data validation is enabled in a list. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif NumberAsText When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, selected cells that contain numbers written as text. False disables error checking for numbers written as text. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif OmittedCells When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, the selected cells that contain formulas referring to a range that omits adjacent cells that could be included. False disables error checking for omitted cells. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242239.properties(en-us,office.12).gif TextDate When set to True (default), Microsoft Excel identifies, with an AutoCorrect Options button, cells that contain a text date with a two-digit year. False disables error checking for cells containing a text date with a two-digit year. Read/write Boolean.
Bb242239.properties(en-us,office.12).gif UnlockedFormulaCells When set to True (default), Microsoft Excel identifies selected cells that are unlocked and contain a formula. False disables error checking for unlocked cells that contain formulas. Read/write Boolean.