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 loopExecutes a sequence of statements multiple times and abbreviates the code that manages the loop variable.|
|2||for ..each loopThis is executed if there is at least one element in the group and reiterated for each element in a group.|
|3||while..wend loopThis tests the condition before executing the loop body.|
|4||do..while loopsThe 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 loopsThe 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 statementTerminates the For loop statement and transfers the execution to the statement immediately following the loop|
|2||Exit Do statementTerminates the Do While statement and transfers the execution to the statement immediately following the loop|