Exportar (0) Imprimir
Expandir todo
Application Property
BackgroundChecking Property
Creator Property
EmptyCellReferences Property
EvaluateToError Property
InconsistentFormula Property
IndicatorColorIndex Property
ListDataValidation Property
NumberAsText Property
OmittedCells Property
Parent Property
TextDate Property
UnlockedFormulaCells Property
Expandir Minimizar

ErrorCheckingOptions Properties

  Name Description
Application Returns an Application object that represents the Microsoft Excel application.
BackgroundChecking Alerts the user for all cells that violate enabled error-checking rules.
Creator Returns a 32-bit integer that indicates the application in which this object was created.
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 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 When set to True (default), Microsoft Excel identifies cells containing an inconsistent formula in a region. False disables the inconsistent formula check.
IndicatorColorIndex Returns or sets the color of the indicator for error checking options.
ListDataValidation A Boolean value that is True if data validation is enabled in a list.
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 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 Returns the parent object for the specified object.
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 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.
Mostrar:
© 2014 Microsoft