Parameter Properties

Name

Returns

Description

DataType

XlParameter DataType

Set/Get the data type of the parameter

Name

String

Set/Get the name of the parameter

Prompt String

String

Read-only. Returns the prompt that is displayed to the user when prompted for a parameter value

Name

Returns

Description

RefreshOn

Boolean

Set/Get whether the query table results are refreshed

Change

when the parameter value changes

Source Range

Range

Read-only. Returns the range of text that contains the

parameter value

Type XlParameter Read-only. Returns the type of parameter (for example,

Type xlConstant, xlPrompt, or xlRange). XlConstant means that the Value parameter has the value of the parameter. XlPrompt means that the user is prompted for the value. XlRange means that the value defines the cell range that contains the value

Value Variant Read-only. Returns the parameter value

0 0

Post a comment