Using Like operator in the Select Case statement
Select Case sProductName
....Case Is Like "* tea *", Is Like "* coffee *"
....Case Like "* beer *", Like "* wine *" ' the Is keyword could be optional
End Select
10
votes
1 comment
-
Robert Einhorn
commented