PivotField.MemberPropertyCaption Property

Setting the MemberPropertyCaption property controls which member property is used as caption for a given level. Read/write Boolean.

Version Information
 Version Added:  Excel 2007

Syntax

expression.MemberPropertyCaption

expression   A variable that represents a PivotField object.

Remarks

Note
This setting has a visual effect only when UseMemberPropertyAsCaption is set to True for the PivotField.

When MemberPropertyCaption is set, the setting is remembered while toggling the UseMemberPropertyAsCaption property.

See Also

• PivotField Object
• PivotField Object Members