Edit

Share via

PivotField.MemberPropertyCaption property (Excel)

  • Article

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

Syntax

expression.MemberPropertyCaption

expression A variable that represents a PivotField object.

Remarks

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.