| condition | Numeric or string expression that is true or false. If condition is Null, then condition is treated as false. |
|---|---|
| statements | One or more statements that are repeated while or until condition is true. |
The Exit Do can only be used within a Do...Loop control structure to provide an alternate way to exit a Do...Loop. Any number of Exit Do statements may be placed anywhere in the Do...Loop. Often used with the evaluation of some condition (for example If...Then). Exit Do transfers control to the statement immediately following the Loop.
When used within nested Do...Loop statements, then Exit Do transfers control to the loop that is nested one level above the loop where it occurs.
Do Until DefResp = vbNo DefResp = MsgBox(MyNum & "Do you want another number?", vbYesNo)LoopDim Check, CounterCheck = true: Counter = 0 'Initialize variablesDo 'Outer loop Do While Counter < 20 'Inner loop Counter = Counter + 1 'Increment Counter variable If Counter = 10 Then Check = false Exit Do 'Exit inner loop End If LoopLoop Until Check = false 'Exit outer loop immediately