Microsoft® Office Excel 2003 Programming Inside Out

Chapter 5. Creating Sub and Function Procedures

Defining Sub Procedures

Defining Function Procedures

Organizing for Success

The first several chapters of this book, but particularly Chapter 4, used sample procedures to illustrate how you can use Visual Basic for Applications (VBA) to make Microsoft Excel do your bidding. The goal in Chapter 4 was to introduce the programming constructs you can use to create and control how your VBA code operates, whether that means repeating a bit of code a set number of times using a For...Next loop, operating on every member of a collection using a For Each...Next loop, or repeating the code until a condition is met. There was a lot of hand waving at that stage when it came to putting your code into a usable ...