Please note javascript is required for full website functionality.


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.  

The iteration structure executes a sequence of statements repeatedly if a condition holds true. There are three main types of loops in VBA:

  1. While…Wend

  1. FOR

  1. DO

We’ll take a look at each of these in turn over the next three blogs.