XlBuiltInDialog Enumeration
Specifies which dialog box to display.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlDialogActivate | 103 | Activate dialog box |
| xlDialogActiveCellFont | 476 | Active Cell Font dialog box |
| xlDialogAddChartAutoformat | 390 | Add Chart Autoformat dialog box |
| xlDialogAddinManager | 321 | Addin Manager dialog box |
| xlDialogAlignment | 43 | Alignment dialog box |
| xlDialogApplyNames | 133 | Apply Names dialog box |
| xlDialogApplyStyle | 212 | Apply Style dialog box |
| xlDialogAppMove | 170 | AppMove dialog box |
| xlDialogAppSize | 171 | AppSize dialog box |
| xlDialogArrangeAll | 12 | Arrange All dialog box |
| xlDialogAssignToObject | 213 | Assign To Object dialog box |
| xlDialogAssignToTool | 293 | Assign To Tool dialog box |
| xlDialogAttachText | 80 | Attach Text dialog box |
| xlDialogAttachToolbars | 323 | Attach Toolbars dialog box |
| xlDialogAutoCorrect | 485 | Auto Correct dialog box |
| xlDialogAxes | 78 | Axes dialog box |
| xlDialogBorder | 45 | Border dialog box |
| xlDialogCalculation | 32 | Calculation dialog box |
| xlDialogCellProtection | 46 | Cell Protection dialog box |
| xlDialogChangeLink | 166 | Change Link dialog box |
| xlDialogChartAddData | 392 | Chart Add Data dialog box |
| xlDialogChartLocation | 527 | Chart Location dialog box |
| xlDialogChartOptionsDataLabelMultiple | 724 | Chart Options DataLabel Multiple dialog box |
| xlDialogChartOptionsDataLabels | 505 | Chart Options DataLabels dialog box |
| xlDialogChartOptionsDataTable | 506 | Chart Options DataTable dialog box |
| xlDialogChartSourceData | 540 | Chart SourceData dialog box |
| xlDialogChartTrend | 350 | Chart Trend dialog box |
| xlDialogChartType | 526 | Chart Type dialog box |
| xlDialogChartWizard | 288 | ChartWizard dialog box |
| xlDialogCheckboxProperties | 435 | Checkbox Properties dialog box |
| xlDialogClear | 52 | Clear dialog box |
| xlDialogColorPalette | 161 | Color Palette dialog box |
| xlDialogColumnWidth | 47 | Column Width dialog box |
| xlDialogCombination | 73 | Combination dialog box |
| xlDialogConditionalFormatting | 583 | Conditional Formatting dialog box |
| xlDialogConsolidate | 191 | Consolidate dialog box |
| xlDialogCopyChart | 147 | Copy Chart dialog box |
| xlDialogCopyPicture | 108 | Copy Picture dialog box |
| xlDialogCreateList | 796 | Create List dialog box |
| xlDialogCreateNames | 62 | Create Names dialog box |
| xlDialogCreatePublisher | 217 | Create Publisher dialog box |
| xlDialogCustomizeToolbar | 276 | Customize Toolbar dialog box |
| xlDialogCustomViews | 493 | Custom Views dialog box |
| xlDialogDataDelete | 36 | Data Delete dialog box |
| xlDialogDataLabel | 379 | Data Label dialog box |
| xlDialogDataLabelMultiple | 723 | Data Label Multiple dialog box |
| xlDialogDataSeries | 40 | Data Series dialog box |
| xlDialogDataValidation | 525 | Data Validation dialog box |
| xlDialogDefineName | 61 | Define Name dialog box |
| xlDialogDefineStyle | 229 | Define Style dialog box |
| xlDialogDeleteFormat | 111 | Delete Format dialog box |
| xlDialogDeleteName | 110 | Delete Name dialog box |
| xlDialogDemote | 203 | Demote dialog box |
| xlDialogDisplay | 27 | Display dialog box |
| xlDialogDocumentInspector | 862 | Document Inspector dialog box |
| xlDialogEditboxProperties | 438 | Editbox Properties dialog box |
| xlDialogEditColor | 223 | Edit Color dialog box |
| xlDialogEditDelete | 54 | Edit Delete dialog box |
| xlDialogEditionOptions | 251 | Edition Options dialog box |
| xlDialogEditSeries | 228 | Edit Series dialog box |
| xlDialogErrorbarX | 463 | Errorbar X dialog box |
| xlDialogErrorbarY | 464 | Errorbar Y dialog box |
| xlDialogErrorChecking | 732 | Error Checking dialog box |
| xlDialogEvaluateFormula | 709 | Evaluate Formula dialog box |
| xlDialogExternalDataProperties | 530 | External Data Properties dialog box |
| xlDialogExtract | 35 | Extract dialog box |
| xlDialogFileDelete | 6 | File Delete dialog box |
| xlDialogFileSharing | 481 | File Sharing dialog box |
| xlDialogFillGroup | 200 | Fill Group dialog box |
| xlDialogFillWorkgroup | 301 | Fill Workgroup dialog box |
| xlDialogFilter | 447 | Dialog Filter dialog box |
| xlDialogFilterAdvanced | 370 | Filter Advanced dialog box |
| xlDialogFindFile | 475 | Find File dialog box |
| xlDialogFont | 26 | Font dialog box |
| xlDialogFontProperties | 381 | Font Properties dialog box |
| xlDialogFormatAuto | 269 | Format Auto dialog box |
| xlDialogFormatChart | 465 | Format Chart dialog box |
| xlDialogFormatCharttype | 423 | Format Charttype dialog box |
| xlDialogFormatFont | 150 | Format Font dialog box |
| xlDialogFormatLegend | 88 | Format Legend dialog box |
| xlDialogFormatMain | 225 | Format Main dialog box |
| xlDialogFormatMove | 128 | Format Move dialog box |
| xlDialogFormatNumber | 42 | Format Number dialog box |
| xlDialogFormatOverlay | 226 | Format Overlay dialog box |
| xlDialogFormatSize | 129 | Format Size dialog box |
| xlDialogFormatText | 89 | Format Text dialog box |
| xlDialogFormulaFind | 64 | Formula Find dialog box |
| xlDialogFormulaGoto | 63 | Formula Goto dialog box |
| xlDialogFormulaReplace | 130 | Formula Replace dialog box |
| xlDialogFunctionWizard | 450 | Function Wizard dialog box |
| xlDialogGallery3dArea | 193 | Gallery 3D Area dialog box |
| xlDialogGallery3dBar | 272 | Gallery 3D Bar dialog box |
| xlDialogGallery3dColumn | 194 | Gallery 3D Column dialog box |
| xlDialogGallery3dLine | 195 | Gallery 3D Line dialog box |
| xlDialogGallery3dPie | 196 | Gallery 3D Pie dialog box |
| xlDialogGallery3dSurface | 273 | Gallery 3D Surface dialog box |
| xlDialogGalleryArea | 67 | Gallery Area dialog box |
| xlDialogGalleryBar | 68 | Gallery Bar dialog box |
| xlDialogGalleryColumn | 69 | Gallery Column dialog box |
| xlDialogGalleryCustom | 388 | Gallery Custom dialog box |
| xlDialogGalleryDoughnut | 344 | Gallery Doughnut dialog box |
| xlDialogGalleryLine | 70 | Gallery Line dialog box |
| xlDialogGalleryPie | 71 | Gallery Pie dialog box |
| xlDialogGalleryRadar | 249 | Gallery Radar dialog box |
| xlDialogGalleryScatter | 72 | Gallery Scatter dialog box |
| xlDialogGoalSeek | 198 | Goal Seek dialog box |
| xlDialogGridlines | 76 | Gridlines dialog box |
| xlDialogImportTextFile | 666 | Import Text File dialog box |
| xlDialogInsert | 55 | Insert dialog box |
| xlDialogInsertHyperlink | 596 | Insert Hyperlink dialog box |
| xlDialogInsertObject | 259 | Insert Object dialog box |
| xlDialogInsertPicture | 342 | Insert Picture dialog box |
| xlDialogInsertTitle | 380 | Insert Title dialog box |
| xlDialogLabelProperties | 436 | Label Properties dialog box |
| xlDialogListboxProperties | 437 | Listbox Properties dialog box |
| xlDialogMacroOptions | 382 | Macro Options dialog box |
| xlDialogMailEditMailer | 470 | Mail Edit Mailer dialog box |
| xlDialogMailLogon | 339 | Mail Logon dialog box |
| xlDialogMailNextLetter | 378 | Mail Next Letter dialog box |
| xlDialogMainChart | 85 | Main Chart dialog box |
| xlDialogMainChartType | 185 | Main Chart Type dialog box |
| xlDialogMenuEditor | 322 | Menu Editor dialog box |
| xlDialogMove | 262 | Move dialog box |
| xlDialogMyPermission | 834 | My Permission dialog box |
| xlDialogNameManager | 977 | NameManager dialog box |
| xlDialogNew | 119 | New dialog box |
| xlDialogNewName | 978 | NewName dialog box |
| xlDialogNewWebQuery | 667 | New Web Query dialog box |
| xlDialogNote | 154 | Note dialog box |
| xlDialogObjectProperties | 207 | Object Properties dialog box |
| xlDialogObjectProtection | 214 | Object Protection dialog box |
| xlDialogOpen | 1 | Open dialog box |
| xlDialogOpenLinks | 2 | Open Links dialog box |
| xlDialogOpenMail | 188 | Open Mail dialog box |
| xlDialogOpenText | 441 | Open Text dialog box |
| xlDialogOptionsCalculation | 318 | Options Calculation dialog box |
| xlDialogOptionsChart | 325 | Options Chart dialog box |
| xlDialogOptionsEdit | 319 | Options Edit dialog box |
| xlDialogOptionsGeneral | 356 | Options General dialog box |
| xlDialogOptionsListsAdd | 458 | Options Lists Add dialog box |
| xlDialogOptionsME | 647 | OptionsME dialog box |
| xlDialogOptionsTransition | 355 | Options Transition dialog box |
| xlDialogOptionsView | 320 | Options View dialog box |
| xlDialogOutline | 142 | Outline dialog box |
| xlDialogOverlay | 86 | Overlay dialog box |
| xlDialogOverlayChartType | 186 | Overlay ChartType dialog box |
| xlDialogPageSetup | 7 | Page Setup dialog box |
| xlDialogParse | 91 | Parse dialog box |
| xlDialogPasteNames | 58 | Paste Names dialog box |
| xlDialogPasteSpecial | 53 | Paste Special dialog box |
| xlDialogPatterns | 84 | Patterns dialog box |
| xlDialogPermission | 832 | Permission dialog box |
| xlDialogPhonetic | 656 | Phonetic dialog box |
| xlDialogPivotCalculatedField | 570 | Pivot Calculated Field dialog box |
| xlDialogPivotCalculatedItem | 572 | Pivot Calculated Item dialog box |
| xlDialogPivotClientServerSet | 689 | Pivot Client Server Set dialog box |
| xlDialogPivotFieldGroup | 433 | Pivot Field Group dialog box |
| xlDialogPivotFieldProperties | 313 | Pivot Field Properties dialog box |
| xlDialogPivotFieldUngroup | 434 | Pivot Field Ungroup dialog box |
| xlDialogPivotShowPages | 421 | Pivot Show Pages dialog box |
| xlDialogPivotSolveOrder | 568 | Pivot Solve Order dialog box |
| xlDialogPivotTableOptions | 567 | Pivot Table Options dialog box |
| xlDialogPivotTableWizard | 312 | Pivot Table Wizard dialog box |
| xlDialogPlacement | 300 | Placement dialog box |
| xlDialogPrint | 8 | Print dialog box |
| xlDialogPrinterSetup | 9 | Printer Setup dialog box |
| xlDialogPrintPreview | 222 | Print Preview dialog box |
| xlDialogPromote | 202 | Promote dialog box |
| xlDialogProperties | 474 | Properties dialog box |
| xlDialogPropertyFields | 754 | Property Fields dialog box |
| xlDialogProtectDocument | 28 | Protect Document dialog box |
| xlDialogProtectSharing | 620 | Protect Sharing dialog box |
| xlDialogPublishAsWebPage | 653 | Publish As WebPage dialog box |
| xlDialogPushbuttonProperties | 445 | Pushbutton Properties dialog box |
| xlDialogReplaceFont | 134 | Replace Font dialog box |
| xlDialogRoutingSlip | 336 | Routing Slip dialog box |
| xlDialogRowHeight | 127 | Row Height dialog box |
| xlDialogRun | 17 | Run dialog box |
| xlDialogSaveAs | 5 | SaveAs dialog box |
| xlDialogSaveCopyAs | 456 | SaveCopyAs dialog box |
| xlDialogSaveNewObject | 208 | Save New Object dialog box |
| xlDialogSaveWorkbook | 145 | Save Workbook dialog box |
| xlDialogSaveWorkspace | 285 | Save Workspace dialog box |
| xlDialogScale | 87 | Scale dialog box |
| xlDialogScenarioAdd | 307 | Scenario Add dialog box |
| xlDialogScenarioCells | 305 | Scenario Cells dialog box |
| xlDialogScenarioEdit | 308 | Scenario Edit dialog box |
| xlDialogScenarioMerge | 473 | Scenario Merge dialog box |
| xlDialogScenarioSummary | 311 | Scenario Summary dialog box |
| xlDialogScrollbarProperties | 420 | Scrollbar Properties dialog box |
| xlDialogSearch | 731 | Search dialog box |
| xlDialogSelectSpecial | 132 | Select Special dialog box |
| xlDialogSendMail | 189 | Send Mail dialog box |
| xlDialogSeriesAxes | 460 | Series Axes dialog box |
| xlDialogSeriesOptions | 557 | Series Options dialog box |
| xlDialogSeriesOrder | 466 | Series Order dialog box |
| xlDialogSeriesShape | 504 | Series Shape dialog box |
| xlDialogSeriesX | 461 | Series X dialog box |
| xlDialogSeriesY | 462 | Series Y dialog box |
| xlDialogSetBackgroundPicture | 509 | Set Background Picture dialog box |
| xlDialogSetPrintTitles | 23 | Set Print Titles dialog box |
| xlDialogSetUpdateStatus | 159 | Set Update Status dialog box |
| xlDialogShowDetail | 204 | Show Detail dialog box |
| xlDialogShowToolbar | 220 | Show Toolbar dialog box |
| xlDialogSize | 261 | Size dialog box |
| xlDialogSort | 39 | Sort dialog box |
| xlDialogSortSpecial | 192 | Sort Special dialog box |
| xlDialogSplit | 137 | Split dialog box |
| xlDialogStandardFont | 190 | Standard Font dialog box |
| xlDialogStandardWidth | 472 | Standard Width dialog box |
| xlDialogStyle | 44 | Style dialog box |
| xlDialogSubscribeTo | 218 | Subscribe To dialog box |
| xlDialogSubtotalCreate | 398 | Subtotal Create dialog box |
| xlDialogSummaryInfo | 474 | Summary Info dialog box |
| xlDialogTable | 41 | Table dialog box |
| xlDialogTabOrder | 394 | Tab Order dialog box |
| xlDialogTextToColumns | 422 | Text To Columns dialog box |
| xlDialogUnhide | 94 | Unhide dialog box |
| xlDialogUpdateLink | 201 | Update Link dialog box |
| xlDialogVbaInsertFile | 328 | VBA Insert File dialog box |
| xlDialogVbaMakeAddin | 478 | VBA Make Addin dialog box |
| xlDialogVbaProcedureDefinition | 330 | VBA Procedure Definition dialog box |
| xlDialogView3d | 197 | View 3D dialog box |
| xlDialogWebOptionsBrowsers | 773 | Web Options Browsers dialog box |
| xlDialogWebOptionsEncoding | 686 | Web Options Encoding dialog box |
| xlDialogWebOptionsFiles | 684 | Web Options Files dialog box |
| xlDialogWebOptionsFonts | 687 | Web Options Fonts dialog box |
| xlDialogWebOptionsGeneral | 683 | Web Options General dialog box |
| xlDialogWebOptionsPictures | 685 | Web Options Pictures dialog box |
| xlDialogWindowMove | 14 | Window Move dialog box |
| xlDialogWindowSize | 13 | Window Size dialog box |
| xlDialogWorkbookAdd | 281 | Workbook Add dialog box |
| xlDialogWorkbookCopy | 283 | Workbook Copy dialog box |
| xlDialogWorkbookInsert | 354 | Workbook Insert dialog box |
| xlDialogWorkbookMove | 282 | Workbook Move dialog box |
| xlDialogWorkbookName | 386 | Workbook Name dialog box |
| xlDialogWorkbookNew | 302 | Workbook New dialog box |
| xlDialogWorkbookOptions | 284 | Workbook Options dialog box |
| xlDialogWorkbookProtect | 417 | Workbook Protect dialog box |
| xlDialogWorkbookTabSplit | 415 | Workbook Tab Split dialog box |
| xlDialogWorkbookUnhide | 384 | Workbook Unhide dialog box |
| xlDialogWorkgroup | 199 | Workgroup dialog box |
| xlDialogWorkspace | 95 | Workspace dialog box |
| xlDialogZoom | 256 | Zoom dialog box |