Forum Discussion
Solved
Excel VBA to filter a table based on multiple search criteria entry in ActiveX Control Textbox
Hello All, (This is a development of the thread Excel 365 ActiveX Textbox for "Search as you type" not working on second monitor - Microsoft Community Hub) I am seeking a solution to the belo...
That is unavoidable; the code has to do a lot of work. In that case, I'd use a command button to filter, instead of reacting to every keystroke.
AutoFilter cannot handle more than 2 criteria with wildcards.
Advanced Filter would be an alternative - you can assemble the criteria range in VBA.
Two other options are described in AutoFilter based on an array, more than 3 elements
Hans, thanks for the response. I think the version 2 solution posted on stackoverflow will work, but how do I link it to work with my file?