# Tutorial Cycle for VBA

**Topics:**Control flow, Programming language, For loop

**Pages:**6 (1326 words)

**Published:**February 25, 2014

Objective:

The objective of this document is to understand the use of the cycle For.in VBA there are three types of cycles: For Next

Do While

Do Until

What is a cycle

Doing the exact same thing several times

For example, if I have 3 dirty plates, what would be my washing procedure? Option 1

Take dirty plate 1

Scrub dirty plate 1

Rinse dirty plate 1

Dry dirty plate 1

Take dirty plate 2

Scrub dirty plate 2

Rinse dirty plate 2

Dry dirty plate 2

Take dirty plate 3

Scrub dirty plate 3

Rinse dirty plate 3

Dry dirty plate 3

Now imagine it being 50 plates.

What does the process mentioned before have in common? What do you observe is repeated? Let’s put a color to what is repeated.

Take dirty plate 1

Scrub dirty plate 1

Rinse dirty plate 1

Dry dirty plate 1

Take dirty plate 2

Scrub dirty plate 2

Rinse dirty plate 2

Dry dirty plate 2

Take dirty plate 3

Scrub dirty plate 3

Rinse dirty plate 3

Dry dirty plate 3

You can observe there are three cycles, this means the same steps are repeated three times, the only thing that changes is the plate number. There is a representation for the cycle in code:

From plate=1 until 3

Take dirty plate

Scrub dirty plate

Rinse dirty plate

Dry dirty plate

Next plate

Summary

1) Before you program, generate your solution for the problem, like the cycle for dish washing, each instruction written independently. You don’t have to identify the pattern right away. 2) When you have your solution, identify the pattern that is repeated, you might have to adjust the instructions sometimes so that they are similar or depend on a variable. 3) Generate the pseudocode of the cycle.

4) Get ready to program.

Example of obtaining a cycle

You have been asked to generate a code to calculate the total funds that have been raised at a charity event. You have to ask how many people have donated money, how much each one donated and give the final result. TRY IT!! AT LEAST COMPLETE THE ALGORITHM AND SEE THE SOLUTION AFTERWARDS!! IF YOU GET STUCK, GO TO THE SOLUTION PART AT THE END, AND TRY TO FIGURE IT OUT!! SOLUTION

Step 1

Generate the solution process without a cycle.

Input

numPeople = Number of people that donated

Amount = Amount donated by person

Output

Total = sum of all the amounts donated by person

Process

Ask for number of people (numPeople)

For 1 person, ask amount

Total = amount

Find out if everyone is accounted for, if they are, print out the total, if they are not then you should continue. For person 2, ask amount

Total = Total + amount (this means I’m accumulating what I had plus what is given to me) Find out if everyone is accounted for, if they are print out the total, if they are not then you should continue. For person 3, ask amount

Total = Total + amount (this means I’m accumulating what I had plus what is given to me) Find out if everyone is accounted for, if they are print out the total, if they are not then you should continue.

Maybe you are seeing a pattern, if you are then go ahead to Step 2. Step 2

Identify the pattern that is repeated. Observe the next patterns that are almost the same. For 1 person, ask amount

Total = amount

Find out if everyone is accounted for, if they are print out the total, if they are not then you should continue. For person 2, ask amount

Total = Total + amount (this means I’m accumulating what I had plus what is given to me) Find out if everyone is accounted for, if they are print out the total, if they are not then you should continue. For person 3, ask amount

Total = Total + amount (this means I’m accumulating what I had plus what is given to me) Find out if everyone is accounted for, if they are print out the total, if they are not then you should continue.

Now, you try to adjust or modify the patterns so that they are equal and you can turn them into a cycle. Total = amount

It can be the same as Total = Total + amount, if total is...

Please join StudyMode to read the full document