This updated and expanded Wrox resource covers how to gain more control over Excel spreadsheets using VBA, enabling users to do anything from automating Excel tasks to eveloping full applications while using Excel as the development environment Brings readers up to speed with Excel and VBA, then expands to focus on major issues faced by Excel users and developers Covers the basics such as setting up applications and converting them to add-ins, packaging and distributing Excel applications, programming the VB Editor, and using the Windows API
The author was awarded as a Visual Developer MVP for his community contributions in the primary area of Visual Basic. Contains more than 400 pages on new topics, and reference appendices are now included on the Web in a downloadable and searchable format
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 Procedure
Chapter 6: Class Modules
Chapter 7: Writing Bulletproof Code
Chapter 8: Debugging and Testing
Chapter 9: UserForms
Chapter 10: Adding Controls
…etc…