Table of Contents:
  • About the Authors; Acknowledgments; Introduction; Chapter 1: Primer in Excel VBA; Chapter 2: Programming in the VBE; Chapter 3: The Application Object; Chapter 4: Object-Oriented Theory and VBA; Chapter 5: Event Procedures; Chapter 6: Class Modules; Chapter 7: Writing Bulletproof Code; Chapter 8: Debugging and Testing; Chapter 9: UserForms; Chapter 10: Adding Controls; Chapter 11: Data Access with ADO; Chapter 12: Creating and Using Add-ins; Chapter 13: Automation Addins and COM Addins; Summary; Chapter 14: Customizing the VBE; Chapter 15: Interacting with Other Office Applications