DialogSheets Method

Applies To

Application Object, Workbook Object.

Description

Accessor. Returns an object that represents a single dialog sheet (a DialogSheet object, Syntax 1) or a collection of all dialog sheets (a DialogSheets object, Syntax 2) in the workbook. Read-only.

Syntax 1

object.DialogSheets(index)

Syntax 2

object.DialogSheets

object

Optional for Application, required for Workbook. The object that contains dialog sheets.

index

Required for Syntax 1. The name or number of the dialog sheet to return.

Remarks

Using this method with no object qualifier is a shortcut for ActiveWorkbook.DialogSheets.

Example

This example displays the custom dialog box on Dialog1. The loop causes the dialog box to be displayed again if you click the Cancel button.

Do
    returnVal = DialogSheets("Dialog1").Show
Loop Until returnVal = True