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 |
---|---|
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
|
No comments:
Post a Comment