Select Case with multiple lines in a case statement?

I'm new to VBA, and working in Excel. I'd like to use a Select Case statement, but all of the examples I find are very simplistic; one line of code in any case statemenet. What notation or syntax should I use if I want to have multiple lines of code in a case statement? For example, in the first case statement below, I added several lines of "code". Do I need parens or anything like that?

I realize this is a really n00b question, but I couldn't find anything when I searched because the terms are pretty vague.

Please Login or Register  to view this content.

Why don't you just simply test with a couple of lines of code...?

Originally Posted by cytop

Why don't you just simply test with a couple of lines of code...?

Who says I'm not already doing extensive testing?

Also, in this case, the testing will also change based on the case statement.

Who says I'm not already doing extensive testing

Please Login or Register  to view this content.

OK, so I was totally expecting my code to fail with some cryptic and useless error, but with multiple lines of code in the case statements, things work fine. There is no need for parens or any other notation in the cases. Comments are fine too.

I don't know if there is an upper limit, but I have 27 lines in my first case statement and it works fine.