vba exit while code example

Example 1: excel vba exit while wend loop

'VBA does NOT have an Exit statement for While Wend loops. While Wend
'loops must run through completion:
While i < 1000
    c = c + 1
Wend

'...or be interrupted by a GoTo statement:  
While i < 1000
    c = c + 1
    If c = 750 Then GoTo MyExit
Wend

MyExit:
'But using a GoTo statement is usually bad coding practice.

Example 2: vba exit while

Do While True
    count = count + 1
    If count = 10 Then
        Exit Do
    End If
Loop