User Forms and Pivot Tables
That worked incredibly well. Thank you so much for your
help. I learned over 5 things from your response. Thanks
again.
-----Original Message-----
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
.
|