Home > Publications & Training > VBA
Web This Site

A book on applied programming concepts with an emphasis on VBA

The web pages linked to the Table of Contents below represent draft chapters on an yet-unnamed book on programming techniques with an emphasis on VBA.

Table of Contents (Draft)
Chapter	Topic
1	Introduction
2	Program statements, basic data structures, and their relationship
3	Defensive programming
4	Key concepts in data structure design
5	Modularity, Functional decompostion, top-down design
6	Error handling
7	Recursion
8	Power of Variants
9	Userform Interface
10	Introduction to Object Oriented Programming (OOP)
11	Event-driven programming
12	Advanced concepts in OOP
13	Automation of applications, including Excel from Excel
14	Optimizing performance
15	Distributing code