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.
Select Case score
Case Is >= 80
line 1 of code
line 2 of code
line 3 of code
result = "very good"
Case Is >= 70
result = "good"
Case Is >= 60
result = "sufficient"
Case Else
result = "insufficient"
End Select
Bookmarks