XlParameterType Enumeration
Collapse the table of content
Expand the table of content
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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)

Dim xlParameterType1 As XlParameterType = XlParameterType.xlConstant

public enum XlParameterType
public enum XlParameterType
public enum XlParameterType

Member nameDescription
xlConstantUses the value specified by the Value argument.
xlPromptDisplays a dialog box that prompts the user for the value. The Value argument specifies the text shown in the dialog box.
xlRangeUses the value of the cell in the upper-left corner of the range. The Value argument specifies a Range object.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

© 2016 Microsoft