select case syntax

tremara1 · #1 (**permalink**) 10-27-2008, 10:24 AM

I would like to use a select case to to find a value in several ranges ie
from 0 to 5 from 6 to 12 and so on. I have tried many combinations but I am not sure of the syntax I need in each case. I know this is going to be simple but I am really stumped...Thanks

klaus · #2 (**permalink**) 10-27-2008, 10:58 AM

From what I know, the only way is this one:

Code:

Select var
Case 0,1,2,3,4,5
Case 6,7,8,9,10
End Select

In Visual Basic it is possible with

Code:

Select Case var
Case 0 To 5
Case 6 To 10
End Select

Erel, couldn't this be an intersting feature ?

Best regards.

Erel · #3 (**permalink**) 10-27-2008, 08:45 PM

Quote:

Erel, couldn't this be an intersting feature ?

Yes. Maybe it will be added in a future version.

tremara1 · #4 (**permalink**) 10-27-2008, 09:38 PM

Thanks for your help its great to be part of a team that helps each other...

moster67 · #5 (**permalink**) 10-31-2008, 12:12 PM

I also would like to see this implemented.

Rgds,
moster67

Quote:

Originally Posted by klaus

In Visual Basic it is possible with

Code:

Select Case var
Case 0 To 5
Case 6 To 10
End Select

Erel, couldn't this be an intersting feature ?