VBA and Macros for Microsoft Excel

5Looping and Flow Control

IN THIS CHAPTER

For...Next Loops

Do Loops

The VBA Loop: For Each

Case Study

Next Steps

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'll also discuss the cool loop construct unique to object oriented languages:

• For Each...Next

For...Next Loops

These are common loop constructs. Everything between For and Next is run multiple times. Each time that the code runs, a certain ...