ParameterType Element (Microsoft Excel)

Specifies a parameter type.

Contained In

Parameter

Remarks

This element contains one of the following string constants:

Constant Description
Prompt Prompt the user for a parameter. Use the PromptString element to specify the prompt string.
Value The parameter is a value. Use the ParameterValue element to specify the data type of the value.
Formula The parameter is the result of a formula. The Formula element specifies the formula.

If this element is not specified, the default type is Prompt.

Example

See the example in the PivotTable element topic.