XlParameterType Enumeration
Specifies how to determine the value of the parameter for the specified query table.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlParameterType
'Usage
Dim instance As XlParameterType
public enum XlParameterType
Members
Member name | Description | |
---|---|---|
xlPrompt | Displays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box. | |
xlConstant | Uses the value specified by the Value argument. | |
xlRange | Uses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object. |