The "Excel 2013 VBA" CD-ROM is not only an excellent learning tool to master VBA, but also a gold mine for very powerful and useful macros. The CD-ROM has more than 1200 PowerPoint slides that guide you through the learning process. In addition, it comes with Excel files for you to work on as well as files that have the VBA code all done.
Contents Table of CD:
Part 1: Basic Essentials
- 1. Object Oriented
- 2. Recording Macros
- 3. Branch Statements
- 4. Interaction
- 5. Variables (Value Type)
- 6. Variables (Object Type)
- 7. Collections
- 8. Loop Statements
- 9. Variables as Arguments
- 10. Pivot Tables and Charts
Part 2: Formulas and Arrays
- 11. Dates and Calendars
- 12. The Current-Region
- 13. Property WorksheetFunction
- 14. Property Formula
- 15. Property FormulaR1C1
- 16. Custom Functions
- 17. Array Functions
- 18. 1D- and 2D-Arrays
- 19. Customized Arrays
- 20. Variant Arrays
Part 3: Buttons, Forms, and more
- 21. Importing and Exporting
- 22. Buttons, Bars, Menus
- 23. Application Events
- 24. User Forms
- 25. Data Entry + Mail Merge
- 26. Custom Classes
- 27. Class Collections
- 28. Error Handling
- 29. Distributing VBA code
- 30. VBA Monitoring VBA
Per maggiori informazioni: "Excel 2013 VBA. A Complete Course in Excel 2013. CD-ROM" di Gerard M Verschuuren, edito da Holy Macro Books, è in vendita anche su Amazon.it al prezzo di Euro 71,36
.
Nessun commento:
Posta un commento