In this topic, we will discuss Loops in visual basic for application.
There may be a situation when you need to execute a block of code several 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.
| Sr.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 |
Pingback: VBA - For Each Loops - Adglob Infosystem Pvt Ltd
Pingback: VBA - For Loops - Adglob Infosystem Pvt Ltd
Pingback: VBA - Exit Do - Adglob Infosystem Pvt Ltd
Pingback: VBA - Exit For - Adglob Infosystem Pvt Ltd
Pingback: VBA - Do-While Loops - Adglob Infosystem Pvt Ltd
Pingback: VBA - While Wend Loops - Adglob Infosystem Pvt Ltd