98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel.advanced.course - Pivot Table
excel.advanced.course - Pivot Table
Resolved · Low Priority · Version Standard
Mon 28 Jan 2008, 11:22Delegate Hari said...
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?.
Sun 10 Feb 2008, 09:44Trainer Stephen said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
