Case is statement with And

[neveu]

hello,

i would need to create a Case is Statement where the criteria is complex, meaning i would have to use the AND.

how should it be written to work?

i would need something like

Select Case valuetocompare
case is <=3 AND case is >1

but if i write it like that i get an error.

any help is greatly appreciated

 

[RoryA]

Don't use Select Case - use If...Then...Else...End If

 

[neveu]

i need to do that because i have like over 20 alternatives

 

[RoryA]

So? There isn't a limit to If statements.

 

[neveu]

would be very hard for me to follow it and write it

 

[doofusboy]

Something like this should work:

Select Case valuetocompare
    Case 1 To 3
        'your code
    Case Else
        'your code
End Select

 

[RoryA]

True - if your complex criteria are simple ranges, then that will work. I confess I simply assumed they were more complicated than that!

 

[ScottR]

would be very hard for me to follow it and write it

Why would they be? The structure is virtually identical.

In my little world since IFs can do everything CASEs can do plus a lot more. CASE = pointless.

 

[RoryA]

Select Case can be much easier to read in a lot of circumstances. On the other hand, IF...End If is, allegedly, more efficient.

 

[Jonmo1]

You don't have to use AND in a Select Case Statement.
It works the same as a Nested If.
It's all in the order you write the case statements...

Select Case SomeValue
    Case Is <=1
        'Do This
    Case Is <=3 
        'here you do not have to test for >1
        'because it's already handled in previous case <=1
        'Do That
    Case Is <=5
        'here you do not have to test for >3
        'because it's already handled in previous case <=3
        'Do Something Else
    Case Else
        'Do Nothing
End Select