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 and 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. XlBuiltInDialog constants and 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)

xlDialogApplyNames (133)

xlDialogFormulaReplace (130)

xlDialogPublishAsWebPage (653)<v9>

xlDialogApplyStyle (212)

xlDialogFunctionWizard (450)

xlDialogPushbuttonProperties (445)

xlDialogAppMove (170)

xlDialogGallery3dArea (193)

xlDialogReplaceFont (134)

xlDialogAppSize (171)

xlDialogGallery3dBar (272)

xlDialogRoutingSlip (336)

xlDialogArrangeAll (12)

xlDialogGallery3dColumn (194)

xlDialogRowHeight (127)

Get Writing Excel Macros with VBA, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.