|Do_Loop||These types of loops should be used with caution and always make sure the loop can be terminated.|
|Do_until||This is executed at least once because the condition is at the bottom.|
|Do_While||You can test the condition either at the top or the bottom of the loop.|
This should be used in situations where the loop will be terminated when a logical condition applied.
|Exit_Do||Provides a way to exit a Do loop|
This transfers control to the statement following the Loop statement.When an Exit Do statement is executed the loop ends immediately. Do - While Loops can contain one or more Exit Do statements.
|Exit_For||This provides a way to exit a For loop|
It can only be used on a For - Next or For Each Loop
Exit For transfers control to the statement following the Next statement.
|For_Each||This gives you access to all the elements in a collection object without knowing exactly how many elements are in the collection.|
All elements in a Collection
|For_Next||This should be applied when you preedict in advanced how many times you want to loop.|
|While_Wend||There is also a While Loop although this is less popular than the Do Loop|
This logic is identical to the Do-While loop.
There is no Exit While in VBA