Or operator

[RichyT]

I can't seem to find the syntax for the or operator so that I can compare a string to a list of strings, eg.

myString Like "one" or "two" or "three"

I feel like I'm being a bit dim!!

Cheers

Rich

 

[LittleSmudge]

I think you mean

((myString = "one&quot Or (myString = "two&quot Or (myString = "three&quot)


QED ?

G LS

 

[RichyT]

Yes, I knew about that syntax, sorry should have mentioned that, but is there no way of doing it so that I don't have to keep repeating myString?

Rich

 

[xlbo]

Not without setting up an array of potential answers and looping through it and then you have the extra typing to set up the loop

Only other way that springs to mind is
Select Case myString
Case "one"
goto linereference
case "two"
goto linereference
case "three"
goto linereference
case else
goto different linereference
End Select

HTH
Geoff

 

[RichyT]

Oh well, thanks anyway.