Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

DialogBox Method [Excel 2003 VBA Language Reference]

Office 2003

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.

expression .DialogBox

expression Required. An expression that returns a Range object. 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
		


Applies to | Range Collection


Show: