The Do...Loop statement can has several different syntax's. The following loops run when the condition is True and stop when the condition is False
Syntax 1:
Do While condition
Statement
Loop
---Or---
Syntax 2:
Do
statement
Loop Whilecondition
The following code displays a message box saying "Do you want to process more data?". When the user presses no the loop stops. This code uses both the above syntax's.
Syntax 1:
Dim Ans As Integer
Do While Ans = vbYes
ProcessData ' Procedure call to process data
Ans = Msgbox ("Do you want to process more data?", vbYesNo)
Loop
---Or---
Syntax 2:
Dim Ans As Integer
Do
ProcessData ' Procedure call to process data
Ans = Msgbox ("Do you want to process more data?",
vbYesNo)
Loop While Ans = vbYes
The Following loops run when the condition is False, and then stops when the condition becomes True.
Do Until condition
Statement
Loop
---Or---
Do
statement
Loop Until condition
Comments