Microsoft KB Archive/117412

= Dialog Constants That Do Not Have an Interactive Dialog =

Article ID: 117412

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q117412





SUMMARY
Microsoft Excel provides a list of built-in constants that can be used in a 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, follow these steps:
 * 1) In a Visual Basic module, click Object Browser on the View menu.
 * 2) From the list of Libraries/Workbooks, click to select Excel.
 * 3) Under Objects/Modules, click to select Constants.

In Microsoft Excel 97, click "XlBuiltInDialog" in the list of Classes.

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

