O'Reilly logo

Writing Excel Macros with VBA, 2nd Edition by Steven Roman PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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)

xlDialogAssignToObject ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required