Repeating Actions in VBA

Now that you've learned how conditional statements can give your VBA procedures decision-making capabilities, it's time to get more involved. Not all decisions are easy. Sometimes you will need to perform a number of statements several times to arrive at a certain condition. On other occasions, however, after you've reached the decision, you may need to run the specified statements as long as a condition is true or until a condition becomes true. In programming, performing repetitive tasks is called looping. VBA has various looping structures that allow you to repeat a sequence of statements a number of times. In this chapter, you learn how to loop through your code.

Visual Basic has two types of Do loop statements that repeat a sequence of statements either as long as or until a certain condition is true: Do...While and Do...Until.

0 0

Post a comment