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.
Do you want to show a row if
(1) the column contains ALL of the keywords, or
(2) the column contains at least ONE of the keywords?
Hans, I want to show all rows that contain ALL keywords on AND basis.
Thanks,
Al
Thanks,
Al
See if the attached version does what you want.
- Hans, thanks for the response. It works on the smaller data sample, but the only issue I have is when I tried it on a large data set: it freezes after each key stroke in the text box.
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.