Hello.
I'm using Excel 2010.
I need an auto filter "as you type" that can work with numbers using VBA. In the attached file, I have two columns: Column A with numbers and Column B with text. I also have two text buttons. The idea is that when I type inside any of those buttons then the data will be automatically (in real time with no need to do anything else) filtered and show the matching rows.
At the moment, I have VBA code working flawlessly for column B, the one containing text. But I cannot make it work for sorting numbers. I have seen some ideas using a helper column but I am trying to avoid that. The existing working code for text does not need a helping column.
Please see attached example.
If there is no other way to pull this off but using a helper column, then can you please modify the excising VBA code used for column B in the attached file? I like this code since it is easier to modify than all other examples I've seen and it works flawlessly.
In advanced, thank you much.
Bookmarks