Select Case Question

[mwa]

Is it possible to have a Select Case statement that checks against multiple values?

Instead of this:

Select Case strValue
     Case "XXX"
         'Do Something
     Case "YYY"
         'Do the same thing
     Case "ZZZ"
         'Do the same thing again
     Case Else
         'Do something Different  
End Select

Is there something like this:

Select Case strValue
     Case ("XXX", "YYY", "ZZZ")
         'Do something
     Case Else
         'Do something Different  
End Select

Thanks In advance...

mwa
<><

 

[Veep]

Yes.


Vince

 

[mwa]

And how is this done?

mwa
<><

 

[TipGiver]

Just remove the "(" and ")

 

[Veep]

Select Case strValue
Case "XXX", "YYY", "ZZZ"
'Do something
Case Else
'Do something Different
End Select



Vince

 

[mwa]

Shoot... I almost had it...

Thanks.

mwa
<><