Table of Contents Section I: Understanding the BASICs Lesson 1. Introducing VBA Lesson 2. Getting Started with Macros Lesson 3. Introducing the Visual Basic Editor Lesson 4. Working in the VBE Section II: Diving Deeper into VBA Lesson 5. Object-oriented Programming — An Overview Lesson 6. Variables, Data Types, and Constants Lesson 7. Understanding Objects and Collections Lesson 8. Making Decisions with VBA Section III: Beyond the Macro Recorder.  Writing Your Own Code Lesson 9. Repeating Actions with Loops Lesson 10. Working with Arrays Lesson 11. Automating Procedures with Worksheet Events Lesson 12. Automating Procedures with Workbook Events Lesson 13. Using Embedded Controls Lesson 14. Programming Charts Lesson 15. Programming PivotTables and PivotCharts Lesson 16. User Defined Functions Lesson 17. Debugging Your Code Section IV: Advanced Programming Techniques Lesson 18. Creating UserForms Lesson 19. UserForm Controls and Their Functions Lesson 20. Advanced UserForms Lesson 21. Class Modules Lesson 22. Add-Ins Lesson 23. Managing External Data Lesson 24. Data Access with ActiveX Data Objects Lesson 25. Not Gone, Not Forgotten Section V: Interacting with Other Office Applications Lesson 26. Overview of Office Automation from Excel Lesson 27. Working with Word from Excel Lesson 28. Working with Outlook from Excel Lesson 29. Working with Access from Excel Lesson 30. Working with PowerPoint from Excel BOOK DETAILS Paperback: 432 pages Publisher: Wrox (May 2011) Language: English ISBN-10: 047089069X ISBN-13: 978-0470890691