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

1 vote201 views1 answer
Excel vba compare 2 rows
VBA
1 vote203 views2 answers
Vba remove first 2 characters from string
VBA
4 votes203 views2 answers
Vba array length
VBA
0 vote213 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote224 views1 answer
Group controls programmatically vb
VBA
0 vote198 views1 answer
Vba get text file content
VBA
0 vote204 views1 answer
Change whcih control a user has selected vb
VBA
0 vote202 views1 answer
Check if program is running vbnet
VBA
0 vote205 views1 answer
Excel vba Column Name to Column Number
VBA
3 votes203 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA