XL98: Dialog Constants That Do Not Have an Interactive Dialog

ID: Q192359

The information in this article applies to:

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

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: XL98
Keywords          : kbdta xlvbainfo 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbinfo

Last Reviewed: September 12, 1998