Pivot Table

[NextStar]

Could someone please help me with the VBA code to determine how many colors are there per product and the ability to determine if their shares match.

How do i do this using VBA code?

I know you can determine RowField(index).name for the whole pivottable object for every RowField but I need to limit it to only the colors per product.

Thanks!

\1

[NextStar]

for example this code reads and loads all the product numbers into a listbox on my form, how do i do the same but limit to to only the colors per product?

For Each pvt In Worksheets("pvi").PivotTables
For j = 1 To pvt.RowFields("Product Number").PivotItems.Count
ListBox3.AddItem pvt.RowFields("Product Number").PivotItems(j).Name
Next j
Next pvt

[teylyn]

Hello NextStar,

welcome to the forum.

However, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I'll add the code tags for you this time, but I'll expect you to use them from now on.

cheers