DO WHILE loop in Excel (VBA and VB6) | Free code

Here you can download free code that shows you how a DO WHILE loop can be used for programming in Excel and VBA when you need to iterate through a data list of values as long as some condition are met.

A DO WHILE loop is a statement in programming that is used to run the same code several times as long as som condition are met. The condition of a DO WHILE loop can be specified at the beginning of the statement or at the end of the statement, a DO WHILE loop begins with Do and ends with Loop.

If the condition of a DO WHILE loop is placed at the beginning of the statement then it is not sure that the loop is executed even once, while it is certain that the loop executes at least once if the condition is placed at the end of the statement. A DO WHILE loop can be stopped prematurely by using the "Exit Do" argument and this can be useful when, for example, a loop has reached the end of a data list.

In this template with free code for a DO WHILE loop we have constructed two identical loops in which one has the condition placed at the beginning of the loop and the second loop have the condition placed at the end of the loop. Updated: 01/01/2015 | Created by All-templates.biz

Download DO WHILE loop in Excel (VBA and VB6) | Free code »

Tags: excel iterations