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.

Loop Architecture

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s