VBA - Loops
There may be a situation when you need to execute a block of code several number of times. In general, statements are executed sequentially: The first statement in a function is executed first, followed by the second, and so on.
Programming languages provide various control structures that allow for more complicated execution paths.
A loop statement allows us to execute a statement or group of statements multiple times. Following is the general form of a loop statement in VBA.
VBA provides the following types of loops to handle looping requirements. Click the following links to check their detail.
| Sr.No. |
Loop Type & Description |
| 1 |
for loop
Executes a sequence of statements multiple times and abbreviates the code that manages the loop variable.
|
| 2 |
for ..each loop
This is executed if there is at least one element in the group and reiterated for each element in a group.
|
| 3 |
while..wend loop
This tests the condition before executing the loop body. |
| 4 |
do..while loops
The do..While statements will be executed as long as the condition is True.(i.e.,) The Loop should be repeated till the condition is False.
|
| 5 |
do..until loops
The do..Until statements will be executed as long as the condition is False.(i.e.,) The Loop should be repeated till the condition is True.
|
Loop Control Statements
Loop control statements change execution from its normal sequence. When execution leaves a scope, all the remaining statements in the loop are NOT executed.
VBA supports the following control statements. Click the following links to check their detail.
| S.No. |
Control Statement & Description |
| 1 |
Exit For statement
Terminates the For loop statement and transfers the execution to the statement immediately following the loop
|
| 2 |
Exit Do statement
Terminates the Do While statement and transfers the execution to the statement immediately following the loop
|
