How to display a pivot table in UserForm on Excel 2003

[aco83r]

Hi guys,

I have a file that contains a 2 worksheets, one for the data, second for pivot table.

Is there a any way to show pivot table from second worksheet in a user form on excel 2003 ?

 

[Somendra Misra]

Hi,

You need Microsoft Office Pivot Table control to do so, try searching in the userform control toolbox, if you don't find it there, try downloading it from below site:

http://support.microsoft.com/kb/828950

Pl. Note: I don't have 2003 so, I had not test it.

Regards,

 

[NARAYANK991]

Hi ,

Some additional information :

http://answers.microsoft.com/en-us/...r/3f873380-da0e-4758-bd57-1b2d0b6a1b78?auth=1

http://www.mrexcel.com/forum/excel-...sheet-visual-basic-applications-userform.html

Narayan