In other words, the Do Loop will perform while the criteria are met. To learn more, launch our Excel VBA financial modeling course online! Do While LoopĪs opposed to the do until loop, the Do While loop will perform the loop until the criteria become false. At Cell A10, the do until criteria n = 10 will have been met, and so the macro will end the loop and move on. Running this macro will fill Cell A1 with Company 1, Cell A2 with Company 2, and so on until Cell A10 is filled with Company 10. For example, you may wish to fill the first ten rows in column A with the text “Company n.” This is done as follows: This type of loop using an integer is useful for running a process a specified number of times. Once n = 10, the macro will pass the loop and continue with the rest of the macro.

Since n is still not 10, the process will repeat 10 times, until n is 10. The first iteration adds 1 to n, turning the value into 1. When it runs into the Do Until loop, the criteria n = 10 is not true, so the process within the loop is run. The macro initially stores a value of 0 in n. In this example, we’ve set an integer variable known as “n”. A simple example of this loop is to increase a counter until it reaches a specified number, as in the example below. The criteriion is inserted right after the “do until” statement. The Do Until Loop will continue repeating until the criteria is true. There are several different types of loops, and each type performs differently. To learn more, launch our Excel VBA financial modeling course online! Macros can contain several separate loops, and loops can contain loops within themselves, indefinitely. This is like the structure of a macro, where the entirety of a macro code is held inside the Sub statement that starts a macro and the End Sub statement that ends it. This can become very useful in making a financial model more efficient.Ī Do Loop statement will have a beginning statement and an ending statement, with the code to perform contained within these two statements. In fact, loops are quite robust in that the user can get creative with the criteria that end the loop, as long as he or she understands how VBA loops work. The coder can set the loop to repeat a specified number of times until a certain variable exceeds a threshold value or until a specific cell is activated. A VBA Do Loop is a subsection within a macro that will “loop” or repeat until some specific criteria are met.

Visual basic for excel for loop