Expand Minimize

XlParameterType Enumeration (Excel)

Published: July 16, 2012

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft