559 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Looping in Visual Basic for Applications macros
Part one of a four-part series of blogs
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
There are essentially three types of loop that you can write in Visual Basic for Applications:
Use FOR ... NEXT when you want to loop a given number of times.
Use DO UNTIL ... LOOP when you want to loop until a condition is true, or the very similar DO WHILE ... LOOP or WHILE ... WEND when you want to loop while a condition is true.
Use FOR EACH ... NEXT when you want to loop over the objects in a collection.
These are in ascending order of usefulness. If you're an experienced VBA programmer, looping over the objects in a collection is nearly always the way to go.
The rest of this blog gives examples of each type of loop, with the possible forms of syntax. You can also learn about looping in VBA on our two-day introduction to VBA course and (in more detail) on our two-day advanced VBA course.
|Parts of this blog|
25 Aytoun Street