A decision structure that is similar to If...ElseIf tests for a match against a discrete value and this Select...Case statement has the general format shown below.

Is an expression, a test value resolves to a single data value.In the Case statements,each of the match values is one of the possible values that matches the test value. The statements within the matching Case are executed and a Case Else option can be provided for a non-match.

The example below is a simple implementation of Select...Case to give you an idea of how it works.