Application.Dialogs Property

Returns a Dialogs collection that represents all built-in dialog boxes. Read-only.



expression   A variable that represents an Application object.


This example displays the Open dialog box (File menu).

Visual Basic for Applications

MVP icon The following code example was provided by MVP Bill Jelen. Bill is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of, which includes more than 300,000 questions and answers about Excel.

The following code example opens an e-mail message in Microsoft Outlook with the current workbook attached.
Visual Basic for Applications
Sub SendIt()
    Application.Dialogs(xlDialogSendMail).Show arg1:="", arg2:="This goes in the subject line"
End Sub

Access one of the built-in dialogs? Dialogs dialogs property Make use of a predefined dialogue box?