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.
VBA supports the following control statements. Click the following links to check their detail.
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