XlParameterType Enumeration
| Excel Developer Reference |
Specifies how to determine the value of the parameter for the specified query table.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlConstant | 1 | Uses the value specified by the Value argument. |
| xlPrompt | 0 | Displays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box. |
| xlRange | 2 | Uses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object. |