Let’s examine the program listed in example 9.4. The loop will end when the condition is met. The above loop means that while the condition is not met, the loop will go on. The structure of a While….Wend Loop is very similar to the Do Loop. Each time after it prints the word “Hello”, it will print four lines of the “Welcome to the VB tutorial” sentences as the inner loop has four repetitions. As the outer loop has five repetitions, it will print the word “Hello” five times. The output of the above program is shown in Figure 9.1. The program will end when the whole cycle of the outer loop is processed.įor counter1=startNumber to endNumber (Step increment)įor counter2=startNumber to endNumber (Step increment) For a nested loop that consists of two loops, the first cycle of the outer loop will be processed first, then it will process the whole repetitive process of the inner loop, then the second cycle of the outer loop will be processed and again the whole repetitive process of the inner loop will be processed. Following is the example of implementing the nested While loop in Visual Basic programming language. You can actually have as many loops as you want in a nested loop provided the loops are not the never-ending type. In Visual Basic, we can use one While loop within another While loop to implement the applications based on our requirements.

In general, statements are executed sequentially.

When you have a loop within a loop, then you have created a nested loop. There may be a situation when you need to execute a block of code several number of times. Loop and it is normally used together with the If….Then… statement. To exit a For….Next Loop, you can place the Exit For statement within the Loop before the whole repetitive process is executed, the command to use is Exitįor. Sometimes the user might want to get out from the It is used in VBA to perform repetitive data manipulation and improve an Excel model. In the above example, we compute the summation of A VBA Do Loop allows the user to repeat a certain process in a macro. You can examine Example 9.2 for its usage. Sometime we need exit to exit a loop earlier when a certain condition is fulfilled.

Visual basic looping