Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » excel.advanced.course - Pivot Table
|
|
|
Bookmark this page|
The UK's most regular 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.advanced.course - Pivot Table
Resolved · Low Priority · Version Standard
Reply
Pivot Table
How can Objects, Method, Properties aspect of VBA related to Pivot Table.Also, can a list fuction used on Pivot table?.
For upcoming training course dates see: Pricing & availability
RE: Pivot Table
Hi HariThankyou 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
|
 |
Identify Your Training Style For The Best Fit Older learners are often put-off at the thought of returning to a 'classroom' to enhance their skills. These days, training providers offer lots of different options allowing you to choose between a variety of training styles that are sure to suit employees. » Article: It training companies |
» Forum post: Indexing |
Please could I have another go at this
