XL2000: Dialog Constants That Do Not Have an Interactive Dialog Box (213457)

MORE INFORMATION

To see a list of the built-in Microsoft Excel dialog box constants, use one of the following methods:

Method 1

For a list of the dialog box constants and their arguments, click Microsoft Visual Basic Help on the Help menu, type built-in dialog box constants in the Office Assistant or the Answer Wizard, and then click Search to view "Built-In Dialog Box Argument Lists."

Method 2

1. In Excel, press ALT+F11 to start the Visual Basic editor.
2. On the Insert menu, click Module.
3. On the View menu, click Object Browser.
4. Click the Project/Library arrow (upper left corner of the module sheet), and then click Excel.
5. Under Classes, click XlBuiltInDialog.

All of the built-in constants designed to display dialog boxes begin with "xlDialog". Some of the constants listed do not have interactive dialog boxes.

An interactive dialog box is one that allows you to chose options or type information. The dialog constants that are included with Excel that do not have interactive dialog boxes are the following: