VBA Blogs: Going Through the Visual Basics – Part 14
23 November 2018
We thought we’d run an elementary series going through the rudiments of Visual Basic for Applications (VBA) as a springboard for newer users. This blog takes a look at iteration control structures.
In a programming, a control structure determines the order in which statements are executed. The iteration control structure is used for repetitively executing a block of code multiple times.
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/vba/vba-part-14/image1.png/e774d10cbbb9450fc45efbe51abdf434.jpg)
The iteration structure executes a sequence of statements repeatedly if a condition holds true. There are three main types of loops in VBA:
- While…Wend
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/vba/vba-part-14/image2.jpeg/a290a339c965c6d55e67b5fbc6e363f1.jpg)
- FOR
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/vba/vba-part-14/image3.jpeg/8442614c4f37f49db019b5fcb94f3a04.jpg)
- DO
![](http://sumproduct-4634.kxcdn.com/img/containers/main/blog-pictures/2018/vba/vba-part-14/image4.jpeg/5d143e89f1ed36467a475af7d4bfd0de.jpg)
We’ll take a look at each of these in turn over the next three blogs.