VBA Blogs: Going Through the Visual Basics – Part 14

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.