Iteration and the Loop Builder
Do While or Until
The Loop Builder is a simple tool to insert the usual loop constructions in your program - see animation below. (Learn: an introduction to Do loops)
![loop builder](loop-builder.gif)
For Each in collection
The For Each loop can be used with arrays and collections, but for collection classes: the VBA Collection class, or such as Sheets or Range in Excel, you will get more support using the corresponding menu.
![range for each](images/range-for-each.png)
![for each in array](images/for-each-in-array.png)
![for each in collection](images/collection_menu.png)