Share via

Parameter Object Members

  • Article
Excel Developer Reference

Represents a single parameter used in a parameter query.

Methods

  Name Description
Bb242406.methods(en-us,office.12).gif SetParam Defines a parameter for the specified query table.

Properties

  Name Description
Bb242406.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242406.properties(en-us,office.12).gif DataType Returns or sets a XlParameterDataType value that represents the data type of the specified query parameter.
Bb242406.properties(en-us,office.12).gif Name Returns or sets a String value representing the name of the object.
Bb242406.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242406.properties(en-us,office.12).gif PromptString Returns the phrase that prompts the user for a parameter value in a parameter query. Read-only String.
Bb242406.properties(en-us,office.12).gif RefreshOnChange True if the specified query table is refreshed whenever you change the parameter value of a parameter query. Read/write Boolean.
Bb242406.properties(en-us,office.12).gif SourceRange Returns a Range object that represents the cell that contains the value of the specified query parameter. Read-only.
Bb242406.properties(en-us,office.12).gif Type Returns a XlParameterType value that represents the parameter type.
Bb242406.properties(en-us,office.12).gif Value Returns a Variant value that represents the parameter value.