Repeating (the Do While statement)

This lesson covers the Do While statement, which repeats only while a condition holds.

Writing Do While condition ... Loop repeats the block for as long as the condition is true.

The sample code joins the number into a message and increases it by one while count is 3 or less.

A common early stumble is forgetting to update the counter inside the loop and ending up in an infinite loop. Whenever you use Do While, make sure something in the body eventually makes the condition false.

In professional work, Do While is used for work such as searching until a cell meeting some condition is found.

📖 Reference code

Sub CountLoop()
    Dim count As Integer
    Dim result As String
    count = 1
    Do While count <= 3
        result = result & "Count: " & count & vbNewLine
        count = count + 1
    Loop
    MsgBox result
End Sub

✍️ Your code

Type your code, then press "Run"

🧪 This site can't compile or run VBA directly, so it checks on the spot whether what you typed matches the reference code (scoring happens entirely in your browser — nothing is sent anywhere).