Might be a stupid question but...

[wick77]

I was wondering if its possible to break out of an event. I mean I have an event that happens and after certain criteria are met I want to break out of the event without executing the rest of the code. I know break is a keyword in some programming languages and I was wondering if theres something like it in VB.

Any response would be appreciated, thanks,
Wick

[Jamagei]

exit sub

would do it, i think!

[Stevie]

Just use Exit Sub.

[Stevie]

Doh!

Not quick enough.

[Jamagei]

ha haa

p.s just ignore the signature

[wick77]

Thanks guys, it must be early in the morning for me...DUH!

[G.Kumaraguru]

There are many EXITS depending from where you would like to exit..

Exit Do
Exit For
Exit Function
Exit Property
Exit Sub


Exit Do Provides a way to exit a Do...Loop statement. It can be used only inside a Do...Loop statement. Exit Do transfers control to the statement following the Loop statement. When used within nested Do...Loop statements, Exit Do transfers control to the loop that is one nested level above the loop where Exit Do occurs.

Exit For Provides a way to exit a For loop. It can be used only in a For...Next or For Each...Next loop. Exit For transfers control to the statement following the Next statement. When used within nested For loops, Exit For transfers control to the loop that is one nested level above the loop where Exit For occurs.

Exit Function Immediately exits the Function procedure in which it appears. Execution continues with the statement following the statement that called the Function.

Exit Property Immediately exits the Property procedure in which it appears. Execution continues with the statement following the statement that called the Property procedure.

Exit Sub Immediately exits the Sub procedure in which it appears. Execution continues with the statement following the statement that called the Sub procedure.
Remarks

Do not confuse Exit statements with End statements. Exit does not define the end of a structure.

- Courtesy : Microsoft VB HELP File