Do...Loop Statement

āĻļāĻ°ā§āϤāϟāĻŋ True āĻšāϞ⧇ āĻ…āĻĨāĻŦāĻž True āύāĻž āĻšāĻ“ā§ŸāĻž āĻĒāĻ°ā§āϝāĻ¨ā§āϤ Do āĻāĻŦāĻ‚ āϞ⧁āĻĒ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āĻŽāĻ§ā§āϝ⧇ āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

āϏāĻŋāύāĻŸā§āϝāĻžāĻ•ā§āϏ

Do [{While | Until} condition = True]

āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ•

[Exit Do]

āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ•

Loop

or

Do

āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ•

[Exit Do]

āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ•

Loop [{While | Until} condition = True]

āĻĒā§āϝāĻžāϰāĻžāĻŽāĻŋāϟāĻžāϰ/āĻāϞāĻŋāĻŽā§‡āĻ¨ā§āϟ

āĻ…āĻŦāĻ¸ā§āĻĨāĻž: āĻāĻ•āϟāĻŋ āϤ⧁āϞāύāĻžāĻŽā§‚āϞāĻ•, āϏāĻ‚āĻ–ā§āϝāĻžāϏ⧂āϚāĻ• āĻ…āĻĨāĻŦāĻž āĻ¸ā§āĻŸā§āϰāĻŋāĻ‚ āĻāĻ•ā§āϏāĻĒā§āϰ⧇āĻļāύ, āϝāĻž āĻšā§Ÿ True āĻ…āĻĨāĻŦāĻž False āĻšāĻŋāϏ⧇āĻŦ⧇ āĻŽā§‚āĻ˛ā§āϝāĻžā§ŸāĻŋāϤ āĻšā§ŸāĨ¤

āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ•: āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āϝāĻž āĻļāĻ°ā§āϤāϟāĻŋ True āĻšāϞ⧇ āĻ…āĻĨāĻŦāĻž True āύāĻž āĻšāĻ“ā§ŸāĻž āĻĒāĻ°ā§āϝāĻ¨ā§āϤ āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰāϤ⧇ āϚāĻžāύāĨ¤

āĻāĻ•āϟāĻŋ āύāĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āϟ āĻļāĻ°ā§āϤ True āύāĻž āĻšāĻ“ā§ŸāĻž āĻĒāĻ°ā§āϝāĻ¨ā§āϤ Do...Loop āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟāϟāĻŋ āϚāĻžāϞāĻžāύ⧋ āĻšā§ŸāĨ¤ āĻ…āĻŦāĻļā§āϝāχ Do āĻ…āĻĨāĻŦāĻž Loop āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻ…āύ⧁āϏāϰāĻŖ āĻ•āϰ⧇ āϞ⧁āĻĒ āĻĨ⧇āϕ⧇ āĻĒā§āϰāĻ¸ā§āĻĨāĻžāύ⧇āϰ āĻļāĻ°ā§āϤ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāϤ⧇ āĻšāĻŦ⧇āĨ¤ āύāĻŋāĻšā§‡āϰ āωāĻĻāĻžāĻšāϰāĻŖāϏāĻŽā§‚āĻš āĻšāϞ⧋ āĻŦ⧈āϧ āϏāĻŽāĻžāĻšāĻžāϰ:

āϏāĻŋāύāĻŸā§āϝāĻžāĻ•ā§āϏ

Do While condition = True

...statement block

Loop

āĻļāĻ°ā§āϤāϟāĻŋ āϝāĻĻāĻŋ True āύāĻž āĻšā§Ÿ āϤāĻžāĻšāϞ⧇ Do While āĻāĻŦāĻ‚ āϞ⧁āĻĒ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āĻŽāĻ§ā§āϝ⧇ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ• āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

Do Until condition = True

...statement block

Loop

āĻļāĻ°ā§āϤāϟāĻŋ āϝāĻĻāĻŋ false āύāĻž āĻšā§Ÿ āϤāĻžāĻšāϞ⧇ Do āĻāĻŦāĻ‚ āϞ⧁āĻĒ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āĻŽāĻ§ā§āϝ⧇ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ• āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

Do

...statement block

Loop While condition = True

āĻļāĻ°ā§āϤāϟāĻŋ āϝāĻĻāĻŋ True āύāĻž āĻšā§Ÿ āϤāĻžāĻšāϞ⧇ Do āĻāĻŦāĻ‚ āϞ⧁āĻĒ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āĻŽāĻ§ā§āϝ⧇ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ• āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

Do

...statement block

Loop Until condition = True

āĻļāĻ°ā§āϤāϟāĻŋ True āύāĻž āĻšāĻ“ā§ŸāĻž āĻĒāĻ°ā§āϝāĻ¨ā§āϤ Do āĻāĻŦāĻ‚ āϞ⧁āĻĒ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āĻŽāĻ§ā§āϝ⧇ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟ āĻŦā§āϞāĻ• āĻĒ⧁āύāϰāĻžāĻŦ⧃āĻ¤ā§āϤāĻŋ āĻ•āϰ⧇ āĻĨāĻžāϕ⧇āĨ¤

āĻļāĻ°ā§āϤāĻšā§€āύāĻ­āĻžāĻŦ⧇ āϞ⧁āĻĒāϟāĻŋ āϏāĻŽāĻžāĻĒā§āϤ āĻ•āϰāĻžāϰ āϜāĻ¨ā§āϝ Exit Do āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟāϟāĻŋ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧁āύāĨ¤ āφāĻĒāύāĻŋ Do...Loop āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āĻŸā§‡āϰ āϝ⧇āϕ⧋āύ⧋ āĻ¸ā§āĻĨāĻžāύ⧇ āĻāχ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟāϟāĻŋ āϝ⧋āĻ— āĻ•āϰāϤ⧇ āĻĒāĻžāϰ⧇āύāĨ¤ āφāĻĒāύāĻŋ āύāĻŋāĻŽā§āύāϰ⧂āĻĒ⧇ If...Then āĻ•āĻžāĻ āĻžāĻŽā§‹ āĻŦā§āϝāĻŦāĻšāĻžāϰ āĻ•āϰ⧇ āĻĒā§āϰāĻ¸ā§āĻĨāĻžāύ āĻ¸ā§āĻŸā§‡āϟāĻŽā§‡āĻ¨ā§āϟāϟāĻŋ āύāĻŋāĻ°ā§āϧāĻžāϰāĻŖ āĻ•āϰāϤ⧇ āĻĒāĻžāϰ⧇āύ:

Do...

statements

If condition = True Then Exit Do

statements

Loop...

āωāĻĻāĻžāĻšāϰāĻŖ


Sub ExampleDoLoop
Dim sFile As String
Dim sPath As String
    sPath = "c:\"
    sFile = Dir$( sPath ,22)
    If sFile <> "" Then
        Do
            MsgBox sFile
            sFile = Dir$
        Loop Until sFile = ""
    End If
End Sub

Please support us!