Select Case tests one value against a list of cases, including lists, ranges, and comparisons. It replaces long ElseIf chains.

Code

Select Case region
  Case "West", "East": rate = 0.1
  Case Is > 5: rate = 0.2
  Case Else: rate = 0
End Select

• Mixed cases

  Select Case region Case "West", "East": rate = 0.1 Case Is > 5: rate = 0.2 Case Else: rate = 0 End Select → Lists, comparisons, and a default

  The full toolkit.

• Ranges

  Select Case score Case 90 To 100: grade = "A" Case 80 To 89: grade = "B" Case Else: grade = "F" End Select → Numeric ranges

  Grade bands.

• Select Case True

  Select Case True Case x > 10 And y > 10: ... Case x > 10: ... End Select → The first true condition wins

  Complex conditions in order.

• Only the first matching Case runs.
• Case Else catches surprises; always include one.
• Case Is > 5 needs the word Is for comparisons.

• String matching is case sensitive by default.
• Overlapping ranges silently take the first match.