Displays the built-in dialog box and waits for the user to input data. Boolean.
expression.Show(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)
expression Required. An expression that returns one of the above objects.
arg1, arg2, ..., arg30 Optional Variant. For built-in dialog boxes only, the initial arguments for the command. For more information, see the "Remarks" section.
Arg1 Optional Variant.
Arg2 Optional Variant.
Arg3 Optional Variant.
Arg4 Optional Variant.
Arg5 Optional Variant.
Arg6 Optional Variant.
Arg7 Optional Variant.
Arg8 Optional Variant.
Arg9 Optional Variant.
Arg10 Optional Variant.
Arg11 Optional Variant.
Arg12 Optional Variant.
Arg13 Optional Variant.
Arg14 Optional Variant.
Arg15 Optional Variant.
Arg16 Optional Variant.
Arg17 Optional Variant.
Arg18 Optional Variant.
Arg19 Optional Variant.
Arg20 Optional Variant.
Arg21 Optional Variant.
Arg22 Optional Variant.
Arg23 Optional Variant.
Arg24 Optional Variant.
Arg25 Optional Variant.
Arg26 Optional Variant.
Arg27 Optional Variant.
Arg28 Optional Variant.
Arg29 Optional Variant.
Arg30 Optional Variant.
Show method as it applies to the Range and Scenario objects.
For Range objects, scrolls through the contents of the active window to move the range into view. The range must consist of a single cell in the active document. For Scenario objects, shows the scenario by inserting its values on the worksheet. The affected cells are the changing cells of the scenario. Variant.
expression.Show
expression Required. An expression that returns one of the above objects.
Show method as it applies to the CustomView object.
expression.Show
expression Required. An expression that returns one of the above objects.
Remarks
For built in dialog boxes, this method returns True if the user clicks OK, or it returns False if the user clicks Cancel.
You can use a single dialog box to change many properties at the same time. For example, you can use the Format Cells dialog box to change all the properties of the Font object.
For some built-in dialog boxes (the Open dialog box, for example), you can set initial values using arg1, arg2, ..., arg30. To find the arguments to set, locate the corresponding dialog box constant in Built-In Dialog Box Argument Lists. For example, search for the xlDialogOpen constant to find the arguments for the Open dialog box. For more information about built-in dialog boxes, see the Dialogs collection.
Example
This example displays the Open dialog box.
Application.Dialogs(xlDialogOpen).Show