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 vote208 views1 answer
Vba select file in folder
VBA
0 vote264 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote230 views1 answer
Vbnet display all axis labels in cahrt
VBA
3 votes244 views1 answer
Extract the nth word from a text string
VBA
0 vote184 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote234 views1 answer
Vba optional
VBA
0 vote240 views1 answer
Sendkeys vba selenium
VBA
0 vote243 views1 answer
Type excel.application is not defined vb
VBA
0 vote250 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote252 views1 answer
Excel vba textbox forecolor disabled
VBA