Microsoft Office Tutorials and References
In Depth Information
Chapter 13. Built-In Dialog Boxes
Chapter 13. Built-In Dialog Boxes
The Excel object model contains a Dialog object for each of Excel's built-in dialog boxes. These
Dialog objects are kept in the Dialogs collection and are indexed by the XlBuiltInDialog
constants shown in Table 13-1 a nd Table 13-2 . The Dialogs collection is returned by the Dialogs
property of the Application object. In Table 13-1 , "<vX>" indicates that the constant is new for
Excel version X.
Table 13-1. XlB uiltInDialog constants a nd values
_xlDialogChartSourceData (541)<v9>
xlDialogFormatMove (128)
xlDialogPrinterSetup (9)
_xlDialogPhonetic (538)<v9>
xlDialogFormatNumber (42)
xlDialogPrintPreview (222)
xlDialogActivate (103)
xlDialogFormatOverlay (226)
xlDialogPromote (202)
xlDialogActiveCellFont (476)
xlDialogFormatSize (129)
xlDialogProperties (474)
xlDialogAddChartAutoformat (390)
xlDialogFormatText (89)
xlDialogPropertyFields (754)<v10>
xlDialogAddinManager (321)
xlDialogFormulaFind (64)
xlDialogProtectDocument (28)
xlDialogAlignment (43)
xlDialogFormulaGoto (63)
xlDialogProtectSharing (620)
xlDialogPublishAsWebPage
653)<v9> (
xlDialogApplyNames (133)
xlDialogFormulaReplace (130)
xlDialogPushbuttonProperties
445) (
xlDialogApplyStyle (212)
xlDialogFunctionWizard (450)
xlDialogAppMove (170)
xlDialogGallery3dArea (193)
xlDialogReplaceFont (134)
xlDialogAppSize (171)
xlDialogGallery3dBar (272)
xlDialogRoutingSlip (336)
xlDialogArrangeAll (12)
xlDialogGallery3dColumn (194) xlDialogRowHeight (127)
xlDialogAssignToObject (213)
xlDialogGallery3dLine (195)
xlDialogRun (17)
xlDialogAssignToTool (293)
xlDialogGallery3dPie (196)
xlDialogSaveAs (5)
xlDialogAttachText (80)
xlDialogGallery3dSurface (273) xlDialogSaveCopyAs (456)
xlDialogAttachToolbars (323)
xlDialogGalleryArea (67)
xlDialogSaveNewObject (208)
xlDialogAutoCorrect (485)
xlDialogGalleryBar (68)
xlDialogSaveWorkbook (145)
xlDialogAxes (78)
xlDialogGalleryColumn (69)
xlDialogSaveWorkspace (285)
xlDialogBorder (45)
xlDialogGalleryCustom (388)
xlDialogScale (87)
xlDialogCalculation (32)
xlDialogGalleryDoughnut (344) xlDialogScenarioAdd (307)
xlDialogCellProtection (46)
xlDialogGalleryLine (70)
xlDialogScenarioCells (305)
xlDialogChangeLink (166)
xlDialogGalleryPie (71)
xlDialogScenarioEdit (308)
xlDialogChartAddData (392)
xlDialogGalleryRadar (249)
xlDialogScenarioMerge (473)
xlDialogChartLocation (527)
xlDialogGalleryScatter (72)
xlDialogScenarioSummary (311)
xlDialogChartOptionsDataLabelMultiple
(724)<v10>
xlDialogGoalSeek (198)
xlDialogScrollbarProperties (420)
xlDialogChartOptionsDataLabels (505)
xlDialogGridlines (76)
xlDialogSearch (731)<v10>
xlDialogImportTextFile
666)<v9> (
xlDialogChartOptionsDataTable (506)
xlDialogSelectSpecial (132)
xlDialogChartSourceData (540)
xlDialogInsert (55)
xlDialogSendMail (189)
xlDialogChartTrend (350)
xlDialogInsertHyperlink (596)
xlDialogSeriesAxes (460)
xlDialogChartType (526)
xlDialogInsertNameLabel (496)
xlDialogSeriesOptions (557)
xlDialogChartWizard (288)
xlDialogInsertObject (259)
xlDialogSeriesOrder (466)
xlDialogCheckboxProperties (435)
xlDialogInsertPicture (342)
xlDialogSeriesShape (504)
xlDialogClear (52)
xlDialogInsertTitle (380)
xlDialogSeriesX (461)
xlDialogColorPalette (161)
xlDialogLabelProperties (436)
xlDialogSeriesY (462)
xlDialogSetBackgroundPicture
509) (
xlDialogColumnWidth (47)
xlDialogListboxProperties (437)
xlDialogCombination (73)
xlDialogMacroOptions (382)
xlDialogSetPrintTitles (23)
xlDialogConditionalFormatting (583)
xlDialogMailEditMailer (470)
xlDialogSetUpdateStatus (159)
xlDialogConsolidate (191)
xlDialogMailLogon (339)
xlDialogShowDetail (204)
 
 
Search JabSto ::




Custom Search