PivotField.MemberPropertyCaption property (Excel)

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



expression A variable that represents a PivotField object.


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.