Dialogs.Item Property

Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a Dialogs object.

Parameters

Name Required/Optional Data Type Description
Index Required XlBuiltInDialog Variant. The name or index number of the object.

Example

This example displays the Open dialog box and selects the Read-Only option.

Visual Basic for Applications
  Application.Dialogs.Item(xlDialogOpen).Show arg3:=True

See Also