Dialog Object

The Dialog object references each of the built-in dialog boxes available in Excel. Excel stores these dialog boxes in the Dialogs collection. You can use the constant value associated with each Excel dialog box object to view the dialog. You can view individual dialog boxes by using the Show method.

The names for each of the dialog boxes begin with xlDialog followed by a unique value that references the appropriate dialog box. For example, xlSaveAs references the Save As dialog box in Excel.

This object refers only to existing Excel dialog boxes. It does not refer to any new dialog boxes that you may create. For information about creating dialog boxes, see Chapter 12.

0 0

Post a comment