XL: Dialog Constants That Do Not Have an Interactive Dialog

Last reviewed: February 3, 1998
Article 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
  • Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel, when a module sheet is active, you can click Object Browser on the View menu. To see a list of the built-in Microsoft Excel dialog box constants, do the following:

  1. In a Visual Basic module, click Object Browser on the View menu.

  2. From the list of Libraries/Workbooks, select Excel.

  3. Under Objects/Modules, select Constants.

    In Microsoft Excel 97 or Microsoft Excel 98, 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 enter 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 XL98 XL97 XL7 XL5
Keywords : kbprg xlvbainfo PgmOthr PgmRsvd
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 3, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.