VBA Multiple If Comparison (1 Viewer)

Hi All,

What I'm about to ask may seem pretty basic, although I Haven't fount it's answer yet....

What I need to do is to evaluate a condition like:


Actually, is like that but with 22 "ORs". It works but it I think it's the ugly way of doing it. I was wondering if any of you know how to do it like you do that in SQL, like usin a sentence like :


I hope you can help me with this issue.

Thanks in advance,
Victor

How about a Select Case?

Select Case PL
Case "X", "YT", "PG", "WL", "ZO", "QL
etc


Brian

Another method for consideration is the InStr() function ...

If InStr(1,"|X|YT|PG|WL|ZO|QL|","|" & PL & "|") > 0 Then ...

Thanks guys!