Dialogs Interface

A collection of all the Dialog objects in Microsoft Excel.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00020879-0000-0000-C000-000000000046")> _
Public Interface Dialogs _
    Inherits IEnumerable
'Usage
Dim instance As Dialogs
[InterfaceTypeAttribute()]
[GuidAttribute("00020879-0000-0000-C000-000000000046")]
public interface Dialogs : IEnumerable

Remarks

Each Dialog object represents a built-in dialog box. You cannot create a new built-in dialog box or add one to the collection. The only useful thing you can do with a Dialog object is use it with the Show method to display the dialog corresponding dialog box.

Use the Dialogs property to return the Dialogs collection.

Use Dialogs(index), where index is a built-in constant identifying the dialog box, to return a single Dialog object.

Microsoft Excel includes built-in constants for many of the built-in dialog boxes. Each constant is formed from the prefix "xlDialog" followed by the name of the dialog box. For example, the Apply Names dialog box constant is xlDialogApplyNames, and the Find File dialog box constant is xlDialogFindFile. These constants are members of the XlBuiltInDialog enumerated type.

See Also

Reference

Dialogs Members

Microsoft.Office.Interop.Excel Namespace