Do [{While | Until} condition] [statements] [Exit Do] [statements] Loop
Or, you can use this syntax:
Do [statements] [Exit Do] [statements] Loop [{While | Until} condition]
Parameters
Remarks
Any number of Exit Do statements may be placed anywhere in the Do…Loop as an alternate way to exit a Do…Loop. Exit Do is often used after evaluating some condition, for example, If…Then, in which case the Exit Do statement transfers control to the statement immediately following the Loop.
When used within nested Do…Loop statements, Exit Do transfers control to the loop that is one nested level above the loop where Exit Do occurs.
Exit Statement | For...Next Statement | Making Faster For...Next Loops | Using Do...Loop Statements | While…End While Statement