book
Excel 2003 VBA Programmer's Reference
by Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg
July 2004
Beginner
1176 pages
27h 45m
English
Content preview from Excel 2003 VBA Programmer's ReferenceBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial



Contents
Chapter 1: Primer in Excel VBA
Experimenting in the Immediate Window
Calling Functions and Subroutines
Scope and Lifetime of Variables
Chapter 2: Programming in the VBE
Importing and Exporting Visual Basic Code
Chapter 3: The Application Object
Chapter 4: Object-Oriented Theory and VBA
Comparing Classes and Interfaces
Implementing Recursive Methods
Eliminating Recursion with Loops
Information Hiding and Access Modifiers