There are certain tasks in programming that will require you to do things over and over again. For instance, you might need to count the number of iterations that have to be performed to come up with an optimal solution or you might have to count the number of times you have to multiply a number to get to a good approximation. Counting these things may be okay if you are dealing with small numbers but if you are dealing with a lot of counting, it is better to leave it to the computer.

In this chapter you will learn how to:

• take advantage of loops
• use the For Loop and the Do Loop
• use your programming within a user form context.

In This Chapter:

For Loop

How to use the For Loop

Do Loops

How to use Do, Do While and Do Until loops

Loops and User Forms

Using Loops with User Forms