Name
Do...Loop Statement
Syntax
Do [{While | Until} condition]
[statements]
[Exit Do]
[statements]
Loopor:
Do [statements] [Exit Do] [statements] Loop [{While | Until}condition]
-
condition(optional; Boolean expression) An expression that evaluates to
TrueorFalse-
statements(optional) Program statements that are repeatedly executed while, or until,
conditionisTrue
Description
Repeatedly executes a block of code while or until a condition
becomes True
Rules at a Glance
On its own,
Do...Loopinfinitely executes the code that is contained within its boundaries. You therefore need to specify within the code under what conditions the loop is to stop repeating. In addition, if the loop executes more than once, the variable controlling loop execution must be modified inside of the loop. For example:Do intCtr = intCtr + 1 ' Modify loop control variable MsgBox("Iteration " & intCtr & " of the Do loop...") ' Compare to upper limit If intCtr = 10 Then Exit Sub LoopFailure to do this results in the creation of an endless loop.
Adding the
Untilkeyword afterDoinstructs your program toDosomethingUntilthe condition isTrue. Its syntax is:Do Until
condition'code to execute LoopIf
conditionisTruebefore your code gets to theDostatement, the code within theDo...Loopis ignored.Adding the
Whilekeyword afterDorepeats the code while a particular condition isTrue. When the condition becomesFalse, the loop is automatically exited. The syntax of theDoWhilestatement is:Do While
condition ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access