Hello everyone!
I've been searching around the web and have run across some instances of people successfully implementing a Pivot Table, including functionality, into a Userform. Several mentions of the following control have been made:
Microsoft Office PivotTable 11.0 Control
I tried following the directions given to add the Control to the toolbox:
1. Under the VBA menu, I went to Tools: References... and added the Microsoft ActiveX Data Objects 2.1 Library
2. Used "Ctrl-T" to access the Components menu and search for the Microsoft Office PivotTable 11.0 Control.
But it, nor any variation of it, is in the list.
Has anyone successfully embedded a Pivot Table, with functionality, into a userform? I'm using Excel 2013 (32-bit
).
Many thanks!
I've been searching around the web and have run across some instances of people successfully implementing a Pivot Table, including functionality, into a Userform. Several mentions of the following control have been made:
Microsoft Office PivotTable 11.0 Control
I tried following the directions given to add the Control to the toolbox:
1. Under the VBA menu, I went to Tools: References... and added the Microsoft ActiveX Data Objects 2.1 Library
2. Used "Ctrl-T" to access the Components menu and search for the Microsoft Office PivotTable 11.0 Control.
But it, nor any variation of it, is in the list.
Has anyone successfully embedded a Pivot Table, with functionality, into a userform? I'm using Excel 2013 (32-bit
).Many thanks!
