Select Case

• Syntax …

  Select Case <variable>
  
  Case <value>
  <statements>
  Case <value>
  <statements>
  …
  End Select

• Only one alternative

is chosen

• Use else if you need “for all other cases”

• Don’t forget the End Select

Select Case size

Case “short”
basePrice = 1.10
Case “tall”
basePrice = 1.50
Case “grande”
basePrice = 1.90
Case Else
MsgBox “What size?”
End Select

Previous slide

Next slide

Back to first slide

View graphic version