David wrote:
I need help figuring out some code. I need to be able to
click on a button on a userform and have it bring up
another user form that will have information from a pivot
table that resides on a worksheet within the excel
workbook. All I need is for the pivot table to show just
like it does on the worksheet.


Does it have to be a userform?
Easier on an Excel 5 dialog

Right-click sheet tab / Insert / Excel 5 dialog
Select pivot table
Edit / Copy
Activate dialog sheet
Shift+Edit / Paste Picture Link

Drag picture into position.
Show the dialog with ThisWorkbook.DialogSheets("Dialog1").Show

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup