How do i loop prematurely?

[djblois1]

I have a loop that if a condition is met I need it to loop early. How is that possible?

Here is the code:

Please Login or Register  to view this content.

I cannot use an else on the if statement for this purpose because I have other ifs that are needed. for different purposes.

[rvasquez]

Hello there,

Try this:

Please Login or Register  to view this content.

[MarvinP]

Hi,

I'm a fan of the For...Next loop but there are others that I think you are needing here. The list of loop types are at: http://www.anthony-vba.kefra.com/vba/vbabasic3.htm
Perhaps you need a Do While construct to accomplish your "premature" loop.

[djblois1]

rvasquez,

Thank you for your help but I have too much other code that I cannot use the elseif.

Marvin,

I use For Next very often but I don't think it can be used in this situation. Also a Do While loop will not give me a premature loop it will stop when the condition is met (at least that is how I understand it)

[jaslake]

Hi djblois1
Have you considered a "GoTo" statement

[snb]

Please give an example.
I don't see your 'problem'.

[rvasquez]

Could you post your entire code?

[djblois1]

Jaslake that is what I do now, I use a goto statement. I was wondering if there was a more elegant way to do this. I am pretty positive there is a way to do it in more advanced programming languages.