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 vote195 views1 answer
Regex numeric digits
VBA
0 vote187 views1 answer
Loop through lines in text file vb net
VBA
8 votes201 views1 answer
Run command pormpt in background windows
VBA
0 vote191 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote190 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote184 views1 answer
Vbscript Trim
VBA
0 vote187 views1 answer
Telephon call in vba
VBA
4 votes183 views2 answers
Vba array length
VBA
4 votes196 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
5 votes197 views1 answer
Excel vba left word from Long Integer
VBA