| 1 If You've Never Programmed Before |
| The Idea of a Program |
| The Concept of Assignment |
| Decisions and Loops |
| A Simple Example |
| 2 Overview of VBA for Excel |
| The Excel/VBA Environment |
| An Excel Interface and a VBA Macro Program |
| Other Ways to Obtain and Display Information |
| 3 Recording Macros |
| Macro Recording |
| Absolute and Relative References |
| Using Macro Recording to Learn about VBA |
| What Keyboard Macros Can't Do |
| 4 Customized Worksheet Functions |
| The Idea of a Function |
| Worksheet Function Macros |
| 5 Modular Programming |
| Sub Procedures |
| Function Procedures |
| More about Procedure Arguments |
| Passing by Value or by Reference |
| Static Variables |
| 6 Object-Oriented Programming |
| Objects, Properties, Methods, and Collections |
| Using Oop for Input/Output |
| Learning More about Oop |
| 7 Debugging and Testing |
| Debugging |
| The VBA Help Facility |
| Built-in Debugging Capabilities |
| Testing |
| 8 Data Typing and Variable Scope |
| Data Types |
| Type Declaration |
| Variable Scope and Lifetime |
| 9 Computations |
| Computations |
| Built-in Numeric Functions |
| 10 Strings and Dialog Boxes |
| String Functions and Manipulations |
| Message Boxes |
| Input Boxes |
| 11 Structured Programming: Decisions |
| Structured Programming |
| Flowcharts |
| The If/Then/Else Decision Structure |
| The If/Then/Elseif Structure |
| Selected Case Structure |
| Nesting |
| Compound Logical Expressions |
| 12 Structured Programming: Lops |
| Decision Loops (Do/if Exit) |
| Count-Controlled Loops |
| Nesting of Loops and Decisions |
| Recursion |
| 13 Data Structures: Arrays and Records |
| Arrays |
| Records |
| 14 Creating and Accessing Files |
| Sequential Files |
| Other File Operations |
| 15 Custom Dialogue Boxes |
| A Simple Custom Dialogue Box |
| Custom Dialogue Boxes and Modules |
