IF and OR

If your list is that much long and it really makes sense to shorten the test, you can just do

Select a Case 1,2,3,4,5
    Print "A is 1 or 2 or 3 or 4 or 5" 
End Select