- VBA - Userforms
- VBA - Programming Charts
- VBA - Text Files
- VBA - Excel Objects
- VBA - Error Handling
- VBA - Events
- VBA - Sub Procedure
- VBA - Functions
- VBA - Arrays
- VBA - Date and Time
- VBA - Strings
- VBA - Loops
- VBA - Decisions
- VBA - Operators
- VBA - Constants
- VBA - Variables
- VBA - Input Box
- VBA - Message Box
- VBA - Macro Comments
- VBA - Excel Terms
- VBA - Excel Macros
- VBA - Overview
- VBA - Home
VBA Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
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 comppcated 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/images/loop_architecture.jpg)
VBA provides the following types of loops to handle looping requirements. Cpck the following pnks to check their detail.
Sr.No. | Loop Type & Description |
---|---|
1 |
Executes a sequence of statements multiple times and abbreviates the code that manages the loop variable. |
2 |
This is executed if there is at least one element in the group and reiterated for each element in a group. |
3 |
This tests the condition before executing the loop body. |
4 |
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 |
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. Cpck the following pnks to check their detail.
S.No. | Control Statement & Description |
---|---|
1 |
Terminates the For loop statement and transfers the execution to the statement immediately following the loop |
2 |
Terminates the Do While statement and transfers the execution to the statement immediately following the loop |