About Select ... case

[JJM]

Hi,

I would like to use:
Select value
case 30 to 50
cl=cRed
case 51 to 75
cl=cYellow
....
End select

I think it's not good.
has Somebody the solution?

Bye

JJ M

 

[Erel]

'to' is not supported in a Select Case.
You can only use:
Case 30,31,32...
Which is not useful here.
The simplest solution is to use an If statement instead.

 

[JJM]

Thank you Erel.

JJ M