"while - end while" does not work,

[lezawang]

Hi
I tried to use

while condition
....
end while

as per https://tinyurl.com/y7jnl7xe instruction but did not work
but

while condition
.....
wend

worked fine - https://tinyurl.com/y98mz7o3

so my question, which syntax is correct? Thank you.

 

[gallen]

Do While
    *Your code
Loop

 

[gallen]

Apologies, message sent before I completed:

This is clearer, all loops run without issue.

Sub TestDo()
    x = 10
    Do While x > 0
        Debug.Print x
        x = x - 1
    Loop
    x = 10
    Do
        Debug.Print x
        x = x - 1
    Loop While x > 0
    x = 10
    While x > 0
        Debug.Print x
        x = x - 1
    Wend
End Sub