Forum Discussion
How to create searchable data while filtering automatically ?
I don't know of a way to filter as you type using standard excel functions. You can do it using textboxes for the input, but it does require some vba.
There are instructions here how to set it up.
https://chandoo.org/wp/filter-as-you-type-excel/
Also, I attached an example file you can look at (right click on the worksheet tab, select view code, and you will see the macro code). One thing I did differently is I did not use a linked cell, I just changed the macro code to pull the value directly from the textbox instead of getting it from the linked cell.
Riny_van_Eekelen
Hopefully this would be more clear, it gives me a value error.
I don't know of a way to filter as you type using standard excel functions. You can do it using textboxes for the input, but it does require some vba.
There are instructions here how to set it up.
https://chandoo.org/wp/filter-as-you-type-excel/
Also, I attached an example file you can look at (right click on the worksheet tab, select view code, and you will see the macro code). One thing I did differently is I did not use a linked cell, I just changed the macro code to pull the value directly from the textbox instead of getting it from the linked cell.
This is exactly what i wanted but your using an ActiveX component. i have excel 365 on my MacBook Microsoft via apple doesn't allow me to use activeX only only vba and macro.
kind regards
- Excel's built-in capability gives you what you want.
Click the down-arrow in the header row for the column on which you want to filter. You'll see a list of unique values with checkboxes next to them and a field just above the list where you can enter text.
As you enter characters in the field, Excel will filter the list of values. It will *also* filter the table itself. - Sorry, I've never worked with a mac and didn't realize activex controls aren't an option. Unfortunately, that's the only way I know to do it "as you type."
