Item Method (Parameters Collection)

Applies To

Parameters collection object.

Description

Returns a single Parameter object from a Parameters collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a Parameters object.

Index Required Variant. The name or index number of the parameter.

Example

This example modifies the parameter prompt string.

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