Select case vba

Dim Number 
Number = 8    ' Initialize variable. 
Select Case Number    ' Evaluate Number. 
Case 1 To 5    ' Number between 1 and 5, inclusive. 
    Debug.Print "Between 1 and 5" 
' The following is the only Case clause that evaluates to True. 
Case 6, 7, 8    ' Number between 6 and 8. 
    Debug.Print "Between 6 and 8" 
Case 9 To 10    ' Number is 9 or 10. 
Debug.Print "Greater than 8" 
Case Else    ' Other values. 
    Debug.Print "Not between 1 and 10" 
End Select

Similar codes

0 vote129 views1 answer
Windows Forms dark title bar
VBA
3 votes129 views1 answer
Vba post request json
VBA
0 vote139 views1 answer
For each item in folder outlook vba
VBA
0 vote120 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote135 views1 answer
Excel filter by date not working vba
VBA
0 vote128 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote120 views1 answer
Excel vba copy range with filter
VBA
0 vote125 views1 answer
Limit combobox to list vba
VBA
1 vote122 views1 answer
Excel vba compare 2 rows
VBA
1 vote113 views1 answer
Vba compile error object required
VBA