Parameter object (Excel)
Represents a single parameter used in a parameter query.
The Parameter object is a member of the Parameters collection.
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
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.