Microsoft Office Tutorials and References
In Depth Information
Table 15-5. Additional enums for Excel 9.0
XlCVError (7)
XlPageBreak (2)
XlTickLabelOrientation (5)
XlDataLabelPosition (11)
XlPageBreakExtent (2)
XlTickLabelPosition (4)
XlDataLabelsType (6)
XlPageOrientation (2)
XlTickMark (4)
XlDataSeriesDate (4)
XlPaperSize (42)
XlTimeUnit (3)
XlDataSeriesType (4)
XlParameterDataType (20)
XlToolbarProtection (5)
XlDeleteShiftDirection (2)
XlParameterType (3)
XlTrendlineType (6)
XlDirection (4)
XlPasteSpecialOperation (5)
XlUnderlineStyle (5)
XlDisplayBlanksAs (3)
XlPasteType (6)
XlVAlign (5)
XlDisplayShapes (3)
XlPattern (20)
XlWBATemplate (4)
XlDVAlertStyle (3)
XlPhoneticAlignment (4)
XlWindowState (3)
XlDVType (8)
XlPhoneticCharacterType (4)
XlWindowType (5)
XlEditionFormat (4)
XlPictureAppearance (2)
XlWindowView (2)
XlEditionOptionsOption (8)
XlPictureConvertorType (13)
XlXLMMacroType (3)
XlEditionType (2)
XlPivotFieldCalculation (9)
XlYesNoGuess (3)
XlEnableCancelKey (3)
XlPivotFieldDataType (3)
Table 15-5. Additional enums f or Excel 9.0
XlCmdType (4)
XlHtmlType (4)
XlSourceType (7)
XlColumnDataType (10)
XlLayoutFormType (2)
XlSubtototalLocationType (2)
XlCubeFieldType (2)
XlPivotFormatType (22)
XlWebFormatting (3)
XlDisplayUnit (9)
XlQueryType (6)
XlWebSelectionType (3)
Table 5-6. Additional enums for E xcel 10
XlArabicModes (4)
XlImportDataAs (2)
XlRobustConnect (3)
XlCalculatedMemberType (2)
XlInsertFormatOrigin (2)
XlSearchWithin (2)
XlCalculationInterruptKey (3)
XlLinkStatus (11)
XlSmartTagDisplayMode (3)
XlCalculationState (3)
XlPivotCellType (10)
XlSortDataOption (2)
XlCorruptLoad (3)
XlPivotTableMissingItems (3)
XlSpeakDirection (2)
XlDataLabelSeparator (1)
XlPivotTableVersionList (3)
XlUpdateLinks (3)
XlErrorChecks (7)
XlPrintErrors (4)
XlHebrewModes (4)
XlRangeValueDataType (3)
15.3 The VBA Object Browser
Microsoft does supply a tool for viewing the objects, properties, methods, events, and enums in an
object model. It is called the Microsoft Object Browser, and it is accessible from the View menu
in the VBA IDE (or hit the F2 key). Figure 15-1 s hows the Microsoft Object Browser.
Figure 15-1. The Microsoft Object Browser
 
 
 
Search JabSto ::




Custom Search