Answers for "excel vba while break"

VBA
3

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.
Posted by: Guest on March-26-2020

Code answers related to "VBA"

Browse Popular Code Answers by Language