What's VBA's break keyword? (like in java, break jumps out of the current
loop).

exit sub, exit for, exit do, ...

"vivmaha" wrote:

> What's VBA's break keyword? (like in java, break jumps out of the current
> loop).
>

Goto can also be used, but use it wisely, or you get spaghetti-code


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
:

"vivmaha" wrote:

> exit sub, exit for, exit do, ...
>
> "vivmaha" wrote:
>
> > What's VBA's break keyword? (like in java, break jumps out of the current
> > loop).
> >

Yeah, i'll avoid goto.

Check what dijkstra had to say about it: http://www.acm.org/classics/oct95/

"Wigi" wrote:

> Goto can also be used, but use it wisely, or you get spaghetti-code
>
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
> :
>
> "vivmaha" wrote:
>
> > exit sub, exit for, exit do, ...
> >
> > "vivmaha" wrote:
> >
> > > What's VBA's break keyword? (like in java, break jumps out of the current
> > > loop).
> > >