Range.DialogBox Method

Syntax

expression.DialogBox

expression A variable that represents a Range object.

Return Value
Variant

Remarks

The Range must refer to a dialog box definition table on a Microsoft Excel 4.0 macro sheet.

Example

This example runs a Microsoft Excel 4.0 dialog box and then displays the return value in a message box. The dialogRange variable refers to the dialog box definition table on the Microsoft Excel 4.0 macro sheet named "Macro1."

Visual Basic for Applications
`Set dialogRange = Excel4MacroSheets("Macro1").Range("myDialogBox") result = dialogRange.DialogBox MsgBox result`

dialog dialog box Dialog Box Method dialogbox dialogbox method Run an Excel 4.0 dialogbox?

Displays a dialog box defined by a dialog box definition table on a Microsoft Excel 4.0 macro sheet. Returns the number of the chosen control, or returns False if the user clicks the `Cancel` button.

See also: