Show Method

Microsoft Excel Visual Basic

Show All

Show Method

       

Show method as it applies to the Dialog object.

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.

Displays the custom view.

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