Table of contents
TOC
Collapse the table of content
Expand the table of content

Do...Loop Statement

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Repeats a block of statements while a condition is True or until a condition becomes True.

Syntax

Do [{ While |Until } condition ] [ statements ] [ Exit Do ] [ statements ]

Loop Or, you can use this syntax: Do [ statements ] [ Exit Do ] [ statements ] Loop [{ While |Until } condition ] The Do Loop statement syntax has these parts:

PartDescription
conditionOptional. Numeric expression orstring expression that is True or False. If condition isNull, condition is treated as False.
statementsOne or more statements that are repeated while, or until, condition is True.

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.

Example

This example shows how Do...Loop statements can be used. The inner Do...Loop statement loops 10 times, sets the value of the flag to False, and exits prematurely using the Exit Do statement. The outer loop exits immediately upon checking the value of the flag.

Dim Check, Counter 
Check = True: Counter = 0 ' Initialize variables. 
Do ' Outer loop. 
 Do While Counter < 20 ' Inner loop. 
 Counter = Counter + 1 ' Increment Counter. 
 If Counter = 10 Then ' If condition is True. 
 Check = False ' Set value of flag to False. 
 Exit Do ' Exit inner loop. 
 End If 
 LoopLoop Until Check = False ' Exit outer loop immediately. 
© 2018 Microsoft