Excel 2007 VBA Programming with XML and ASP

Chapter 7Chapter 7

Repeating Actions

in VBA

Do Loops: Do…While and Do…Until + Watching a Pro-

cedure Execute + While…Wend Loop + For…Next Loop

+ For Each…Next Loop + Exiting Loops Early + Nested

Loops + Chapter Summary

183

Now that you’ve learned how conditional statements can give your VBA pro-

cedures decision-making capabilities, it’s time to get more involved. Not all

decisions are easy. Sometimes you will need to perform a number of state-

ments several times to arrive at a certain condition. On other occasions,

however, after you’ve reached the decision, ...