Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
48 lines (30 sloc) 1010 Bytes
title keywords f1_keywords ms.prod api_name ms.assetid ms.date localization_priority
Application.Dialogs property (Excel)
vbaxl10.chm133118
vbaxl10.chm133118
excel
Excel.Application.Dialogs
0d04aa87-9872-23e5-78e3-c9e3da2c8eb5
04/04/2019
Normal

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

The following code example opens an email 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

[!includeSupport and feedback]

You can’t perform that action at this time.