Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Combinations of objects,properties and command
|
|
|
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. |
Combinations of objects,properties and command
Resolved · Low Priority · Version 2003
Reply Thu 19 Mar 2009, 16:49Delegate Felix said...
Felix has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Powerpoint Intermediate Advanced course
Combinations of objects,properties and command
if you did not know the Pivottable function and its associated parameters, how can you learn and write in VBA code?
For upcoming training course dates see: Pricing & availability
RE: combinations of objects,properties and command
Hi Felix
One way to learn how the VBA code works is to record a macro of tou doing the function on the screen.
So if you recorded a macro while you created a Pivot table and then observed the code it would give you an idea how the Pivot table code is written.
The code given to you in the Excel VBA Introduction course is an adaptastion of this using the PivotTableWizard method.
Hope this helps
Carlos
Thu 9 Apr 2009: Automatically marked as resolved.
|