Case issue

[ksilenio]

Hi to everyone .First i'd like to wish you Merry Christmas and a Happy New Year.
Now the issue is. I have this case statement


Select Case CDbl(label.Caption)
the "label.caption" is a number
' now how can i get the range between two numbers . I mean
Select Case CDbl(label.Caption)
case >=450 and <=460
code....
case >=470 and <=480
code ....
' and so on...
How can i syntax this?
Regards

[Paul_Hossler]

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/select-case-statement?f1url=https%3A%2F%2Fmsdn.microsoft.com%2Fquery%2Fdev11.query%3Fap pId%3DDev11IDEF1%26l%3Den-US%26k%3Dk(vblr6.chm1008810)%3Bk(TargetFrameworkMoniker-Office.Version%3Dv16)%26rd%3Dtrue%26f%3D255%26MSPPError%3D-2147217396






Case 450 To 460

......

Case 470 To 480


......




Other ways in the link

[ksilenio]

Hi Paul Thank you for your help Regards

[snb]

You don't need case select



choose((CDbl(label.Caption)-440)\10,"a","bb","ccc","ddddd")

[ksilenio]

Hi Thank you for your reply snb