Application.Dialogs Property (Excel)
Returns a Dialogs collection that represents all built-in dialog boxes. Read-only.
Syntax
expression .Dialogs
expression A variable that represents an Application object.
Example
This example displays the Open dialog box (File menu).
Application.Dialogs(xlDialogOpen).Show
Sample code provided by: .jpg "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
About the Contributor
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.