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.
|S.No.||Loop Type & Description|
Executes a sequence of statements multiple times and abbreviates the code that manages the loop variable.
for ..each loop
This is executed if there is at least one element in the group and reiterated for each element in a group.
This tests the condition before executing the loop body.
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.
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|
Exit For statement
Terminates the For loop statement and transfers the execution to the statement immediately following the loop
Exit Do statement
Terminates the Do While statement and transfers the execution to the statement immediately following the loop