Thursday, January 31, 2019

VBA - Loops

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

No comments:

Post a Comment

No String Argument Constructor/Factory Method to Deserialize From String Value

  In this short article, we will cover in-depth the   JsonMappingException: no String-argument constructor/factory method to deserialize fro...