Another basic question... CASE with a range

  • Thread starter Thread starter Phillips
  • Start date Start date
P

Phillips

How would I do the following? I can not find anything about AND/OR in the
VBA help file...


if a is equal to and greater than x and if a is less than z
q=1

if a is equal to and greater than b and if a is less than c
q =2

if a is equal to and greater than e and if a is less than f
q=3

otherwise

q = 0

etc...

Thank you
Phil
 
Phillips,

what do you want q to be if
a is equal to and greater than x and if a is less than z
AND
a is equal to and greater than b and if a is less than c
AND
a is equal to and greater than e and if a is less than f?

Henry
 
Select Case True
Case a >= x and a < z
q = 1
Case a >= b and a < c
q = 2
Case a >= e and a < f
q = 3
Case else
q = 0
End Select
 
Back
Top