Excel.Parameter.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Parameter object (Excel)	vbaxl10.chm522072	vbaxl10.chm522072	Excel.Parameter	2a30f4ef-2cae-c96d-4480-3ba55fa871e8	03/30/2019	medium

Parameter object (Excel)

Represents a single parameter used in a parameter query.

Remarks

The Parameter object is a member of the Parameters collection.

Example

Use Parameters (index), where index is the index number of the parameter, to return a single Parameter object. The following example modifies the prompt string for parameter one.

With Worksheets(1).QueryTables(1).Parameters(1) 
 .SetParam xlPrompt, "Please " & .PromptString 
End With

Methods

• SetParam

Properties

• Application
• Creator
• DataType
• Name
• Parent
• PromptString
• RefreshOnChange
• SourceRange
• Type
• Value

See also

• Excel Object Model Reference

[!includeSupport and feedback]