Hari has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Pivot Table
How can Objects, Method, Properties aspect of VBA related to Pivot Table.
Also, can a list fuction used on Pivot table?.
RE: Pivot Table
Hi Hari
Thankyou for your question
The object model that relates to the PivotTable contains the following objects
PivotTable
PivotCache
PivotField
PivotItems
PivotChart
Each object has a range of properties and methods.
For example the PivotField object has an orientation property which is used to specify if it is in a column, row, pagefield, or data. The same object has a number of methods including Delete, AddPageItem and autosort
As to your query about list functions could you clarify what you wish to do with the list box and how you want it to relate to the PivotTable
Regards
Stephen
