Break out of a While Wend loop

Question

I am using a While   Wend loop of VBA   Dim count as Integer  While True     count count 1      If count   10 Then           What should be the statement to break the While   Wend loop             Break or Exit While not working     EndIf Wend   I don t want to use condition like  While count lt  10   Wend

User · Answer

Another option would be to set a flag variable as a Boolean and then change that value based on your criteria   Dim count as Integer  Dim flag as Boolean  flag   True  While flag     count   count   1       If count   10 Then          Set the flag to false                   flag   false     End If  Wend

User · Answer

The best way is to use an And clause in your While statement Dim count as Integer count  0 While True And count  lt   10     count count 1     Debug Print count  Wend

User · Answer

A While Wend loop can only be exited prematurely with a GOTO or by exiting from an outer block  Exit sub function or another exitable loop   Change to a Do loop instead   Do While True     count   count   1      If count   10 Then         Exit Do     End If Loop   Or for looping a set number of times   for count   1 to 10    msgbox count next    Exit For can be used above to exit prematurely

[excel] Break out of a While...Wend loop

Examples related to excel

Examples related to vba

Examples related to while-loop