How do we exit a CASE SELECT block?

Question

How do we exit an Excel SELECT CASE block? We have found a Microsoft Docs indicating that you can only use the EXIT SELECT command if it is between the SELECT (or SELECT CASE) and the matching END SELECT. Yet, whenever we try to use this, we get a compile error.

We are attempting to use the EXIT SELECT to end processing commands in one of the case choices if a certain condition is met. However, we don’t seem to have a way to exit prematurely to avoid executing additional commands in the selected case using this command.

joeuser2004 · Answer

LemonPeeler&nbsp;&nbsp;Once again, you are asking a syntax question without showing us the complete context in one form or another.&nbsp;According to Excel VBA help, there is no Exit Select statement.&nbsp; Use a GoTo instead.&nbsp;I think you are looking at documentation for .NET Visual Basic.&nbsp; That is a stand-alone compiler.&nbsp; Technically, it is a different language with different features and possibly different behaviors.&nbsp;Admittedly, I have fallen into the same trap myself, because the two languages are "similar enough" perhaps 90% of the time.

joeuser2004 · Answer

LemonPeeler&nbsp;&nbsp;PS, I meant to add....&nbsp; Are aware that there is an implied "exit select" at the end of each Case block?&nbsp;In other words, for example:&nbsp;Select Case expression&nbsp;&nbsp;&nbsp;&nbsp; Case expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statements&nbsp;&nbsp;&nbsp;&nbsp; Case expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statementsEnd Select&nbsp;is equivalent to:&nbsp;Select Case expression&nbsp;&nbsp;&nbsp;&nbsp; Case expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statements&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GoTo afterEnd&nbsp;&nbsp;&nbsp;&nbsp; Case expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statements&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GoTo afterEndEnd SelectafterEnd:&nbsp;&nbsp;&nbsp;&nbsp; statements&nbsp;&nbsp;So no "exit" or explicit GoTo statement is necessary, if that is all you want.

lemonpeeler · Answer

Thank you for the response. As a novice, we probably missed that the article didn't apply to Excel VBA. Furthermore, we solved this problem in the end when we solved the issue of using the GOTO statement, which was not functioning for us due to another error, which was also resolved. Thank you again!

lemonpeeler · Answer

Again, thank you for taking the time to respond. As you suggest here, this method worked fine after we resolved the issue of our GOTO statement compile error. The compile error resulted after inserting a code line break (underscore) after a THEN statement and before the subsequent commands. Thanks.

lemonpeeler · Answer

Hello Joe, one other question if we may. Can we include a RESUME NEXT in a SELECT CASE routine to exit the select case, without processing subsequent commands, and then process the next item in a FOR loop?

Forum Discussion

How do we exit a CASE SELECT block?

Share

Resources