Topic: Selection Set Filter Question

[fxcastil]

I can create a selection set filter to give me text with words ABC* and HJK* using the following

ReDim intFltrCode(1) As Integer
ReDim varFltrVal(1) As Variant

intFltrCode(0) = 0: varFltrVal(0) = "TEXT"
intFltrCode(1) = 1: varFltrVal(1) = "ABC*, HJK*"     ' this line works

*************************************************

But now I want to use a string variable instead of ABC* and HJK*

strVariable1 = "ABC*"
strVariable2 = "HJK*"

ReDim intFltrCode(1) As Integer
ReDim varFltrVal(1) As Variant

intFltrCode(0) = 0: varFltrVal(0) = "TEXT"
intFltrCode(1) = 1: varFltrVal(1) = strVariable1, strVariable2   ' This Line does NOT work


********************************************

I also tried this and it does not work

Dim MyArray (1 to 2) as String

myArray(1) = "ABC*"
myArray(2) = "HJK*"


ReDim intFltrCode(1) As Integer
ReDim varFltrVal(1) As Variant

intFltrCode(0) = 0: varFltrVal(0) = "TEXT"
intFltrCode(1) = 1: varFltrVal(1) = myArray   ' This Line does NOT work

****************************

If I only use one variable to define Text contents or single word this works

strVariable1 = "ABC*"

ReDim intFltrCode(1) As Integer
ReDim varFltrVal(1) As Variant

intFltrCode(0) = 0: varFltrVal(0) = "TEXT"
intFltrCode(1) = 1: varFltrVal(1) = strVariable1 '  This Line does work but I want to use an OR condition of multiple words

[Jeff_M]

It's been a long time since I used VBA so not sure if this is exactly how strings are concatenated. But essentially, as you found, it must be a single string so just add all the elements together.

intFltrCode(1) = 1: varFltrVal(1) = strVariable1 & "," & strVariable2

[fxcastil]

Thanks, I knew I was just missing someting simple and obvious..........