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 chooses the Cancel button.
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.
Set dialogRange = Excel4MacroSheets("Macro1").Range("myDialogBox")
result = dialogRange.DialogBox
MsgBox result