ErrorCheckingOptions ErrorCheckingOptions ErrorCheckingOptions Interface

Definition

Represents the error-checking options for an application.

public interface class ErrorCheckingOptions
[System.Runtime.InteropServices.Guid("0002445B-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface ErrorCheckingOptions
Public Interface ErrorCheckingOptions
Attributes

Remarks

Use the ErrorCheckingOptions property of the Application object to return an ErrorCheckingOptions object.

Reference the Item[Object] property of the Errors object to view a list of index values associated with error-checking options.

You can use the following properties, which are members of the ErrorCheckingOptions object, to set or return error checking options.

Properties

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

BackgroundChecking BackgroundChecking BackgroundChecking

Alerts the user for all cells that violate enabled error-checking rules.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created.

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

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

InconsistentFormula InconsistentFormula InconsistentFormula

When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region. False disables the inconsistent formula check.

InconsistentTableFormula InconsistentTableFormula InconsistentTableFormula

Returns True if the table formula is inconsistent. Read/write Boolean.

IndicatorColorIndex IndicatorColorIndex IndicatorColorIndex

Returns or sets the color of the indicator for error checking options.

ListDataValidation ListDataValidation ListDataValidation

A Boolean value that is True if data validation is enabled in a list.

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

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

Parent Parent Parent

Returns the parent object for the specified object.

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

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

Applies to