VB code. If statement between two values

[nappyjim]

I have a worksheet where a user input a value. There can be 5 differen
fomulas based on what value the user enters. How do I make a vb scrip
to say

If the value of sheet1 cell A1 is between 1 and 5, do A1-A2.

If the value of sheet1 cell A1 is between 6 and 10, do A1+A

 

[Ron Rosenfeld]

I have a worksheet where a user input a value. There can be 5 different
fomulas based on what value the user enters. How do I make a vb script
to say

If the value of sheet1 cell A1 is between 1 and 5, do A1-A2.

If the value of sheet1 cell A1 is between 6 and 10, do A1+A2

Take a look at Help for Select Case

e.g: Select Case UserInput
Case 1 to 5
Result=A1-A2
Case 6 to 10
result = a1+a2
case else
result ="Out Of Range"
End select