select case problems

  • Thread starter Jesper Fjølner
  • Start date
J

Jesper Fjølner

I wan't to do evaluate a number with < and > - is this possible?
Or do I have to nest a If-then in there somewhere?

Select Case AgeGroup
Case Is < 39
AgeGroup= 1
Case Is > 39 AND <50 'fails here - how is this done?
AgeGroup= 2
Case Is > 49
AgeGroup= 3
End Select
 
M

MikeB

Select Case agegroup
Case Is < 39
agegroup = 1
Case 39 To 50
agegroup = 2
Case Is > 50
agegroup = 3
End Select
 
Top