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.
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.
- Hans, I am applying filter to the result and the table does not retain the search result. What would be a possible solution for this? Thanks in advance.
The attached version uses a helper column named Aux to filter on.
You can hide this column if you wish.
- Hans, thanks for the solution. I am using this in combination with the two-entry search field, this will give the user an option to use two-search field and/or multiple-criteria search field.
Regards,
Al.