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 vote379 views1 answer
Filesystemobject vba reference
VBA
32 votes522 views2 answers
Excel vba column letter
VBA
1 vote333 views1 answer
Excel vba compare 2 rows
VBA
5 votes343 views1 answer
Xl vba double quotes in string literal
VBA
0 vote400 views1 answer
Winforms dark title bar
VBA
2 votes334 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
-1 vote303 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote366 views1 answer
Sort dictionary by key vba
VBA
0 vote349 views1 answer
Vba clear collection
VBA
0 vote340 views1 answer
Vba compare strings
VBA