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...

excel

Formulas and Functions

Macros and VBA

office 365

HansVogelaar
May 08, 2023
alex_n

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.
Sample - Search Filter v02.xlsm31 KB

alex_n

Brass Contributor

Jun 01, 2023

Cangkir

When I copied the code to the actual file and right-sized it by changing the column number to 6 as the search items sit in column 6 it says there's a bug:

alex_n

Brass Contributor

Jun 01, 2023

Also, after applying the multi search, i could not apply filter to the table: it does not return the expected result

Forum Discussion

Excel VBA to filter a table based on multiple search criteria entry in ActiveX Control Textbox

Resources