The Select Case statement lets your program make multiple choices based on the value of a single expression.
The template in a Case statement can contain a single comparison value, or multiple comparison values separated by commas. Each comparison value can be one of the following:
Any expression (must be matched exactly).
A range of values indicated by the To keyword. For example, 10 To 20.
The Is keyword followed by a comparison operator and an expression. For example,
Is < 100.
You can also use To and Is with strings.