Export (0) Print
Expand All
Expand Minimize

XlParameterType Enumeration

Office 2007
Specifies how to determine the value of the parameter for the specified query table.

Version Information
 Version Added:  Excel 2007

xlConstant1Uses the value specified by the Value argument.
xlPrompt0Displays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box.
xlRange2Uses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object.

Community Additions

© 2015 Microsoft