I have a while loop that I want to break out of when a certain condition becomes true. Itried it like this:
while InStr(keywords, " "
bob = InStr(keywords, " "
keyword(i) = Mid(keywords,1,bob)
keywords = MID(keywords, (bob+ 1), LEN(keywords))
IF keyword(i)="" Then
k = k+1
Wend
END IF
Wend
But it doesn't work. Is there a break function or something similar.
Thanks
while InStr(keywords, " "
bob = InStr(keywords, " "
keyword(i) = Mid(keywords,1,bob)
keywords = MID(keywords, (bob+ 1), LEN(keywords))
IF keyword(i)="" Then
k = k+1
Wend
END IF
Wend
But it doesn't work. Is there a break function or something similar.
Thanks