VBA code to replicate ShowDetails function

I know that in a Pivot Table, if you double click a results cell, you can get ShowDetails to create a new worksheet with details behind the results cell.

What I'd like to do is to be able to click a results cell in a pivot table (not double click), and have just part of the details behind that cell appear in cells that are just offset from the pivot table itself.

I believe part of this solution will involve finding out the values of the row grouping items in the pivot table.

Can anyone point me in the right direction? Assume I group on fields AA and BB from my original data and sum over CC.

Thank you in advance!

Bruce

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!