XL: Dialog Constants That Do Not Have an Interactive Dialog
ID: Q117412
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 5.0, 5.0c
-
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
-
Microsoft Excel for Windows NT, version 5.0
-
Microsoft Excel for Windows 95, versions 7.0, 7.0a
-
Microsoft Excel 97 for Windows
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:
- In a Visual Basic module, click Object Browser on the View menu.
- From the list of Libraries/Workbooks, click to select Excel.
- 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
REFERENCES
For more information on using Built-in Constants in Microsoft Excel query
in the Microsoft Knowledge Base on the following words:
Constants Built-in Excel WC0993
Additional query words:
we0993 XL97 XL7 XL5
Keywords : kbprg kbdta PgmRsvd PgmOthr KbVBA
Version : MACINTOSH:5.0,5.0a; WINDOWS:5.0,5.0c,7.0,7.0a,97; winnt:5.0
Platform : MACINTOSH WINDOWS winnt
Issue type : kbhowto