Getting Data from Pivot Table

[avg95]

Hi,

I've got a series of pivot tables in my spreadsheet that show the records on a set of shelves in various different ways. I've written code so that when my workbook opens a right click command called 'edit record' appears on all pivot tables.. I'm trying to use vba to populate a userform so that the record selected can be edited easily. Can I use 'getpivotdata' in vba to determine which pivot table the active cell is in and return the details of the record on the active row?

Thanks in advance for the help