Export (0) Print
Expand All

Dialog.Show Method

Displays the built-in dialog box and waits for the user to input data.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Parameters

Arg1

Optional Object. The initial arguments for the command.

Arg2

Optional Object. The initial arguments for the command.

Arg3

Optional Object. The initial arguments for the command.

Arg4

Optional Object. The initial arguments for the command.

Arg5

Optional Object. The initial arguments for the command.

Arg6

Optional Object. The initial arguments for the command.

Arg7

Optional Object. The initial arguments for the command.

Arg8

Optional Object. The initial arguments for the command.

Arg9

Optional Object. The initial arguments for the command.

Arg10

Optional Object. The initial arguments for the command.

Arg11

Optional Object. The initial arguments for the command.

Arg12

Optional Object. The initial arguments for the command.

Arg13

Optional Object. The initial arguments for the command.

Arg14

Optional Object. The initial arguments for the command.

Arg15

Optional Object. The initial arguments for the command.

Arg16

Optional Object. The initial arguments for the command.

Arg17

Optional Object. The initial arguments for the command.

Arg18

Optional Object. The initial arguments for the command.

Arg19

Optional Object. The initial arguments for the command.

Arg20

Optional Object. The initial arguments for the command.

Arg21

Optional Object. The initial arguments for the command.

Arg22

Optional Object. The initial arguments for the command.

Arg23

Optional Object. The initial arguments for the command.

Arg24

Optional Object. The initial arguments for the command.

Arg25

Optional Object. The initial arguments for the command.

Arg26

Optional Object. The initial arguments for the command.

Arg27

Optional Object. The initial arguments for the command.

Arg28

Optional Object. The initial arguments for the command.

Arg29

Optional Object. The initial arguments for the command.

Arg30

Optional Object. The initial arguments for the command.

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. For more information about built-in dialog boxes, see the Dialogs collection.

Community Additions

Show:
© 2014 Microsoft