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

15 votes261 views2 answers
Xl vba dynamic string array
VBA
1 vote143 views1 answer
Set font for ms chart vb.net
VBA
0 vote144 views1 answer
Vba type variable
VBA
5 votes154 views1 answer
Xlvba double quotes in string literal
VBA
0 vote149 views1 answer
Open file dialog in vb.net
VBA
0 vote143 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote164 views1 answer
Vba cell all borders
VBA
8 votes218 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote169 views1 answer
Amd64 vs arm64 linux
VBA
0 vote145 views1 answer
Windows Presentation Foundation dark title bar
VBA