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 » Combinations of objects,properties and command | Excel forum
Combinations of objects,properties and command | Excel forum
Resolved · Low Priority · Version 2003
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?
Mon 30 Mar 2009, 10:14Trainer Carlos said...
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.
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:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |
