| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA equivalent for SQL 'IN' function
Thanks Tony. I think that the 3rd method will work.
"tony h" wrote: I am not sure of a direct equivalent but three options: 1. You could use a delimited list and then if instr(1, "!A!B!C!" , "!" & myvar & "!") < 0 then etc 2. use Select Case myvar Case "A", "B", "C" 'do my stuff End Select 3 create your own function to do it such as Function myIN(strSearch, ParamArray strIN()) As Boolean Dim v As Variant myIN = False For Each v In strIN() If strSearch = v Then myIN = True Exit For End If Next End Function if myin(myvar,"B","C","A") then Regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=507480 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NZ function equivalent in Excel | Excel Worksheet Functions | |||
| Function Equivalent need | Excel Worksheet Functions | |||
| equivalent for function , please for help | Excel Worksheet Functions | |||
| Looking for the equivalent of a Maxif function | Excel Discussion (Misc queries) | |||
| What is the Excel equivalent of the CELL function? | Excel Worksheet Functions | |||
Threaded Mode
