\<bookmark_value\>Select...Case statement\</bookmark_value\>\<bookmark_value\>Case statement\</bookmark_value\>

Select...Case Statement

Defines one or more statement blocks depending on the value of an expression.

Syntax:


Select Case condition Case expression Statement Block [Case expression2 Statement Block][Case Else] Statement Block End Select

Parameters:

\<emph\>Condition:\</emph\> Any expression that controls if the statement block that follows the respective Case clause is executed.

\<emph\>Expression:\</emph\> Any expression that is compatible with the Condition type expression. The statement block that follows the Case clause is executed if \<emph\>Condition\</emph\> matches \<emph\>Expression\</emph\>.

Example:


Sub ExampleRandomSelect
Dim iVar As Integer
    iVar = Int((15 * Rnd) -2)
    Select Case iVar
        Case 1 To 5
            Print "Number from 1 to 5"
        Case 6, 7, 8
            Print "Number from 6 to 8"
        Case 8 To 10
            Print "Greater than 8"
        Case Else
            Print "Out of range 1 to 10"
    End Select
End Sub

Please support us!