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 vote227 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote264 views1 answer
Vba ternary
VBA
0 vote253 views2 answers
Get unique random number in vb.net
VBA
0 vote276 views1 answer
Visual basic cmd
VBA
0 vote217 views1 answer
Vbnet hex to binary
VBA
3 votes253 views1 answer
Extract word in a text in excel
VBA
0 vote182 views10 answers
Vba excel create event log
VBA
0 vote232 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote225 views1 answer
How to extract a file from an ISO:
VBA
1 vote224 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA