The For loop is another simple loop structure, which is different from other loops like Do loop and While Loop because it specifies a range before the loop could start.
The syntax for the For loop is given below.
For index = start To end [Step step] [Statements] Exit For [Statements] Next index
Let us discuss the For loop structure.
For – keyword indicating the type of loop structure.
index – a variable that acts as index for the loop.
start To end – values that indicates
start of the loop and
end of the loop
Step step – The integer value that indicate how much to increment the loop at each iteration. Default is 1.
statements – some expressions or statements that the loop will execute at each iteration.
Exit For – immediately exit the
Next Index – increment the loop index for next iteration.
Example Program: For Loop
In this example, we will create an
index for the loop and create a variable called
sum. Each iteration of the For loop, we will add a value of
10 to the
sum and display the results when the loop terminates.
Private Sub Command1_Click() Dim sum As Integer, index As Integer sum = 0 For index = 1 To 15 sum = sum + 10 Next index MsgBox ("Sum is equal to" & " " & sum) End Sub
In the code above the index is between
1 to 15 and each time it adds
sum. After the loop is terminated, the total amount of sum is display using a