Nested Loop

[Art W.]

Hello Everyone:

The following loop starts in x then loops thru y 20 times then goes back and finishes x. how do I get it to loop thru x then complete loop y then loop x once more then loop y completely again 20 times then back to x and another 20 y’s. there should be 200 loops today.

Do Until X = 10
            X += 1
            MessageBox.Show("Loop X = " & X)
            Do Until y = 20
                y += 1
                MessageBox.Show("Loop Y = " & y)
            Loop
 
        Loop
        
    End Sub

I need to figure this out as part of a larger program.

Thanks

Art W.

[jmcilhinney]

You might want to try resetting 'y' because you aren't even going to enter the inner loop the second time if the value of 'y' is still the same value that caused you to exit the loop in the first place. Besides that, maybe it's just a poor example but those loops should be For loops anyway, not Do loops.

For x = 1 To 10
    For y = 1 To 20
        MessageBox.Show("y = " & y, "x = " & x)
    Next y
Next x