pivot table value
 

Hi,
I am using Excel 97. I have created a simple pivot table that allows me to
view purchases by one bidder at time.
I have a user form with a combo box in which the user will select the bidder
number (this will filter the pivot table). I would like to show the Grand
Total (and maybe other fields) from the pivot table in a textbox on my
userform. My plans are the use the AfterUpdate event on the
BidderNumberCmb. However, I do not know how to reference the Grand Total
cell since this cell will change with each bid number. Any assistance with
this would be greatly appreciated.
Thanks
Valerie