Returns a Dialogs
collection that represents all built-in dialog boxes. Read-only.
A variable that represents an Application object.
This example displays the Open dialog box (File menu).
Sample code provided by: Bill Jelen, MrExcel.com | About the Contributor
The following code example opens an e-mail message in Microsoft Outlook with the current workbook attached.
Application.Dialogs(xlDialogSendMail).Show arg1:="email@example.com", arg2:="This goes in the subject line"
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.