Iterate In Excel Code Within The

Iterate In Excel Code Within The

You use a WHILE loop when you are not sure how many times you want to execute the VBA code within the loop body.

As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.

If the condition is TRUE, then the VBA code would display a message box with the value of the LTotal variable.

This code would display 4 message boxes with the following values: 1, 2, 3, and 4.

This allows you to have a double loop with 2 different conditions that will be evaluated.

The inner WHILE loop is controlled by the LCounter2 variable.

Within the inner loop, the code would display a message box each time with the value of the LCounter1 - LCounter2.

So in this example, 8 message boxes would be displayed with the following values: 1-8, 1-9, 2-8, 2-9, 3-8, 3-9, 4-8, and 4-9.

This is to ensure that the inner WHILE loop will execute again, as LCounter2 would equal 10 after exiting the inner WHILE loop the first time.

If we left LCounter2 at a value of 10, he condition for the inner WHILE loop code would evaluate to FALSE and terminate the loop every subsequent time.

How To Iterate In Excel For Mac