Microsoft KB Archive/213457

= XL2000: Dialog Constants That Do Not Have an Interactive Dialog Box =

Article ID: 213457

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213457





SUMMARY
Microsoft Excel provides a list of built-in constants that you can use in a Microsoft Visual Basic for Applications macro to display a built-in Excel dialog box. However, some of the built-in constants will not display an interactive dialog box.



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:

xlDialogAppMove

xlDialogAppSize

xlDialogErrorbarX

xlDialogErrorbarY

xlDialogFormatMove

xlDialogMove

xlDialogOpenText

xlDialogOverlayChartType

xlDialogPivotFieldUngroup

xlDialogSaveCopyAs

xlDialogSetControlValue

xlDialogSize

xlDialogSplit

xlDialogVbaProcedureDefinition

xlDialogWindowMove

xlDialogWindowSize

xlDialogWorkbookTabSplit

Additional query words: XL2000

Keywords: kbinfo kbprogramming KB213457

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.