"In" keyword equivalent in VBA

[RealKiwi]

Is there a VBA eqivalent to the 'In' SQL keyword, or am I resigned to using lengthy 'or' statements?

SELECT *
FROM tblName
WHERE fieldname IN ('ax', 'bx', 'cx', dx')

thanks

 

[vbajock]

If your dealing with a set of data like 'ax', 'bx', 'cx', dx', the Split function comes in pretty handy. Is in the help file.

 

[PHV]

And what about something like this?
Select Case varname
Case "ax", "bx", "cx", "dx"
' Your code here
End Select

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[RealKiwi]

Yet another cryptic help file from Microsoft... not surprise there ;-)

 

[RealKiwi]

Thanks PHV, I had that in mind; even had the 6 code lines to do the job. 'In' is so much cleaner!

 

[vbajock]

If the help files are too cryptic, buy a book

 

[Golom]

You can also use InStr to cheat a bit for strings.
[blue][tt]
If Instr ( "ax?bx?cx?dx?", myString & "?" ) > 0 then
[/tt][/blue]