[RESOLVED] select case between 3 values

[isnoend07]

How do I write this select case
Text1 = 50
ThisValue = val(Text1)
Highvalue = 500
MedValue = 100

Select case ThisValue
case is > MedValue and < HighValue
msgbox "medValue"
case is >= Highvalue
msgbox "HighValue"
case else
do nothing
end select

[si_the_geek]

Just think about the conditions, and re-order it:

Select Case ThisValue 
Case >= Highvalue
  msgbox "HighValue"
Case > MedValue 
  msgbox "medValue"
case else

end select

[isnoend07]

Thanks
Didn't know it selected the first true value and not look at the others

[firoz.raj]

Didn't know it selected the first true value and not look at the others

yes, if first true value . it will not go at second case statement . hope it might be help.

Select Case ThisValue 
Case >= Highvalue      'when it is true
  msgbox "HighValue"   'it will come here 
Case > MedValue 
  msgbox "medValue"
case else

end select           'and finally it will come here .