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.
|
_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 ... |
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.
