In

[Zach Ahmed]

Hi All:
Is there a similar function to Inlist(). I have 5 variables that I need to compare of values to. Instead of saying if var1='Data1' or var1='Data2' or Var1='Data3' or var='Data4' or var1='Data5'

What I want to do is something like this:
If var1 inlist('Data1','Data2','Data3','Data4','Data5') Then

Thanks

[si_the_geek]

There's no direct built-in function for that, but there is a nice alternative:

Select case var1 
Case "Data1", "Data2", "Data3", "Data4", "Data5"
   'match - code here
End Select

[Zach Ahmed]

Thanks si_the_geek