• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

G. New Objects in Excel XP > ErrorCheckingOptions Object

Name

ErrorCheckingOptions Object

Synopsis

                  Path: Application - ErrorCheckingOptions

Object

Properties

ErrorCheckingOptions

  • BackgroundChecking( ) As Boolean

  • EmptyCellReferences( ) As Boolean

  • EvaluateToError( ) As Boolean

  • InconsistentFormula( ) As Boolean

  • IndicatorColorIndex( ) As XlColorIndex

  • NumberAsText( ) As Boolean

  • OmittedCells( ) As Boolean

  • TextDate( ) As Boolean

  • UnlockedFormulaCells( ) As Boolean

This object corresponds to the Error Checking tab under the Excel Options dialog box. The ErrorCheckingOptions object’s properties correspond to the check boxes in the aforementioned dialog box tab, as shown in Figure G-1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint