View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Khurram Khurram is offline
external usenet poster
 
Posts: 18
Default Skip LOC in D While Loop

Hi all,
Can anyone tell me if the below scenario is possible. I'm trying to
do this using Excel VBA. Basically if results equals to zero, I do
not want any of the next lines of code to be executed and the code to
loop again. I know I can simply use a GoTO statement using a label
but trying to avoid spaghetti code. Any suggestions please


Function abc As String

Do while (condition is not met)

code line 1
code line 2
results = code line 3

if (results = 0) = True Then goto end of Loop

code line 4
code line 5
code line 6

Loop

End Function


Thank you
Khurram