Searching Within Cells and copying to a list

[chrisandsally]

Hi.

I have some code, see below which runs well. It has a Dropdown = "ComboBox1" with header columns and a search box "TextBox1"

It only searches the beginning of the data in the cell. How could it be modified to search within the cell.

For example if I have a dropdown of Address and the data is 123 High Street, London. and I search for London in won't match because the cell starts with 123.

Any Help?

Please Login or Register  to view this content.

[dflak]

Instead of using advanced filter, you may have to loop through the data doing the match in the reverse direction and using INSTR. It's a slower process since you have to slug it out cell-by-cell rather than copying the range, but it's the only way I can think of. You might also investigate LIKE and pattern matching to get even more flexibility.

[chrisandsally]

Thank you for your time and suggestions.