Expand Minimize

Application.Dialogs Property (Excel)

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

expression .Dialogs

expression A variable that represents an Application object.

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

Application.Dialogs(xlDialogOpen).Show


Sample code provided by: MVP Contributor Bill Jelen, MrExcel.com | About the Contributor

The following code example opens an e-mail message in Microsoft Outlook with the current workbook attached.

Sub SendIt() 
    Application.Dialogs(xlDialogSendMail).Show arg1:="ask@mrexcel.com", arg2:="This goes in the subject line" 
End Sub 

MVP Bill Jelen is the author of more than two dozen books about Microsoft Excel. He is a regular guest on TechTV with Leo Laporte and is the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel.

Show:
© 2014 Microsoft