tags:

views:

33

answers:

1
Q: 

pivot table in userForm in excel vba

Dear All,

Any idea about how to embed/insert pivotTable/pivotChart in a userForm?

*code sample will be great to share.

1000,000 thanks in advance

A: 

Hi,

Did you try looking at the Microsoft Office PivotTable 11.0 Control available when you right-click in the Control toolbox ?

This lets you embed a Pivot Table in a Form.

Cheers,

Trefex  2010-07-06 09:54:22

related questions

How can I refresh all the pivot tables in my excel workbook with a macro?
MS Access - Controlling another database in VBA
Deleting a file in VBA
How do you prevent printing dialog when using Excel PrintOut method
SQLite UDF - VBA Callback
Function Overloading in Excel VBA
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Visual studio automation: Enumerate opened windows upon solution loading.
Hiding data points in Excel line charts
How do I create a status dialog box in Excel
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Templates In VB
Best way to test a MS Access application?
How do I read/write Person metadata from a Word doc stored in SharePoint using VBA or VSTO?
Excel VBA: Alternative IDE
good directory picker for visual basic macros in MS Outlook (2007)
Zoom for a windows form in C#
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Alternating coloring groups of rows in Excel
Word Automation: Write RTF text without going through clipboard
How to parse XML in VBA
Refresh Excel VBA Function Results