Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 5. Looping and Flow Control

IN THIS CHAPTER

For...Next Loops	101
Do Loops	107
The VBA Loop: For Each	111
Flow Control: Using If...Then...Else and Select Case	115
Next Steps	120

Loops are a fundamental component of any programming language. If you’ve taken any programming classes, even BASIC, you’ve likely encountered a For...Next loop. Luckily, VBA supports all the usual loops, plus a special loop that is excellent to use with VBA.

This chapter covers the basic loop constructs:

• For...Next

• Do...While

• Do...Until

• While...Loop

• Until...Loop

We also discuss the cool loop construct unique to object-oriented languages:

• For Each...Next

For...Next Loops

For and Next are common loop constructs. Everything between For and Next is run multiple times. Each time that ...