AutoFilter as you Type

[XL4U]

How can I Type into a textbox and the sheet will autofilter as I am typing?

Thanks

[NewGuy OnBlock]

Here's one place that shows how to autofilter as you type.

YouTube Video example AutoFilter as you type

and

davesexcel website
AutoFilter as you type

[Paul Morgan]

Here is a similar thread
http://www.excelforum.com/excel-gene...-you-type.html

[davesexcel]

In the link provided by Paul Morgan,
there was a question as to if it was possible to use a cell instead of a textbox.

This code: will run as you are typing.

Please Login or Register  to view this content.

If you were using a cell, the code would not kick in until the user hit enter. Then it wouldn't be "AutoFiltering as you type".

[XL4U]

Thanks very much

https://youtu.be/E6Nj2vIvlpI

really shows how to do it