Application.dialogs ()

Excel Help:

Dialogs Object
A collection of all Dialog objects in Microsoft Excel.

Description
Each Dialog object represents a built-in dialog box. You cannot create a new or add a built-in dialog box in the collection. The Dialog object can only be used in the Show method to display the corresponding dialog box.
The Microsoft Excel Visual Basic Object library contains built-in constants for many built-in dialog boxes. The prefix for each constant is "xldialog", followed by the name of the dialog box. For example, theApply Name dialog box constant is xldialogapplynames, andThe Find File dialog box constant is xldialogfindfile. These constants are members of the XlBuiltInDialog enumeration type.
Use Dialogs(index), where index is the built-in constant that identifies the dialog box, to return a single Dialog object. The following example runs the built-in open File dialog box.

For example:

Dlganswer = Application.dialogs (Xldialogopen). Show

XlBuiltInDialog enumeration:

Specifies the dialog box to display. Version information
Added version: Excel 2007

Name	Value	Description
Xldialogactivate	103	The Activate dialog box
Xldialogactivecellfont	476	Active cell Font dialog box
Xldialogaddchartautoformat	390	Add Chart AutoFormat dialog box
Xldialogaddinmanager	321	Add-In Manager dialog box
Xldialogalignment	43	Alignment dialog box
Xldialogapplynames	133	App Name dialog box
Xldialogapplystyle	212	Apply Styles dialog box
Xldialogappmove	170	AppMove dialog box
Xldialogappsize	171	AppSize dialog box
Xldialogarrangeall	12	Rearrange all dialog box
Xldialogassigntoobject	213	Assign macro to Object dialog box
Xldialogassigntotool	293	Assign Macro to Tool dialog box
Xldialogattachtext	80	Attach Text dialog box
Xldialogattachtoolbars	323	Additional Toolbars dialog box
Xldialogautocorrect	485	Auto Correction 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 Position dialog box
Xldialogchartoptionsdatalabelmultiple	724	Chart Options Multiple data Labels dialog box
Xldialogchartoptionsdatalabels	505	Chart Options Data Labels dialog box
Xldialogchartoptionsdatatable	40W	Chart Options Data Table dialog box
Xldialogchartsourcedata	540	Chart Source Data dialog box
Xldialogcharttrend	350	Chart Trend dialog box
Xldialogcharttype	526	Chart Type dialog box
Xldialogchartwizard	288	Chart Wizard dialog box
Xldialogcheckboxproperties	435	check Box Properties dialog box
Xldialogclear	52	Clear dialog box
Xldialogcolorpalette	161	The Color Palette dialog box
Xldialogcolumnwidth	47	Column Width dialog box
Xldialogcombination	73	Combo Chart dialog box
Xldialogconditionalformatting	583	Conditional Formatting dialog box
Xldialogconsolidate	191	Merge Calculation dialog box
Xldialogcopychart	147	Copy Chart dialog box
Xldialogcopypicture	108	Copy Picture dialog box
Xldialogcreatelist	796	Create List dialog box
Xldialogcreatenames	62	Create Name dialog box
Xldialogcreatepublisher	217	Create Publisher dialog box
Xldialogcustomizetoolbar	276	Customize Toolbars dialog box
Xldialogcustomviews	493	The Customize View dialog box
Xldialogdatadelete	36	Data Delete dialog box
Xldialogdatalabel	379	Data Labels dialog box
Xldialogdatalabelmultiple	723	Multiple Data Labels 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	The Display dialog box
Xldialogdocumentinspector	862	Document Inspector Dialog box
Xldialogeditboxproperties	438	Edit Box Properties dialog box
Xldialogeditcolor	223	Edit Color dialog box
Xldialogeditdelete	54	Edit Delete dialog box
Xldialogeditionoptions	251	Edit Options Dialog box
Xldialogeditseries	228	Edit Data Series dialog box
Xldialogerrorbarx	463	Error Bar X dialog box
Xldialogerrorbary	464	Error Bar Y dialog box
Xldialogerrorchecking	732	Error checking dialog box
Xldialogevaluateformula	709	Formula Evaluation 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	Populate Workgroup dialog box
Xldialogfilter	447	dialog box Filter dialog box
xldialogfilteradvanced	370	Advanced Filter dialog box
Xldialogfindfile	475	Find File dialog box
Xldialogfont	26	The Font dialog box
Xldialogfontproperties	58w	Font Properties dialog box
Xldialogformatauto	269	AutoFormat dialog box
Xldialogformatchart	465	Format Chart dialog box
Xldialogformatcharttype	423	Format Chart Type dialog box
Xldialogformatfont	150	Set Font Format dialog box
Xldialogformatlegend	88	Legend Format dialog box
Xldialogformatmain	225	Set Primary Format dialog box
Xldialogformatmove	128	Set Move Format dialog box
Xldialogformatnumber	42	Set Number Format dialog box
Xldialogformatoverlay	226	Set Overlapping Format dialog box
Xldialogformatsize	129	Set Size dialog box
Xldialogformattext	89	Format Text dialog box
Xldialogformulafind	64	Find Formula dialog box
Xldialogformulagoto	63	Go to Formula dialog box
Xldialogformulareplace	130	Replace Formula dialog box
Xldialogfunctionwizard	450	Function Wizard dialog box
Xldialoggallery3darea	193	Three-Dimensional Area Gallery dialog box
Xldialoggallery3dbar	272	Three-dimensional Bar Library dialog box
Xldialoggallery3dcolumn	194	Three-Dimensional Column Gallery dialog box
Xldialoggallery3dline	195	Three-Dimensional Line Gallery dialog box
Xldialoggallery3dpie	196	Three-dimensional Pie Gallery dialog box
Xldialoggallery3dsurface	273	Three-Dimensional Surface Gallery dialog box
Xldialoggalleryarea	67	Area Gallery Dialog box
Xldialoggallerybar	68	Bar Library dialog box
Xldialoggallerycolumn	69	Column Gallery dialog box
Xldialoggallerycustom	388	Customize Library dialog box
Xldialoggallerydoughnut	344	Doughnut Gallery dialog box
Xldialoggalleryline	70	Line Gallery dialog box
Xldialoggallerypie	71	Pie Gallery dialog box
Xldialoggalleryradar	249	Radar dialog box

Application.dialogs ()