There have been a few postings in different newsgroups regarding the number of keystokes involed when invoking a filter selection in Excel 2007.
This reminded me of a conversation I has at a conference some while ago with Dr Peter Grebenik of Brookes University, Oxford, who uses Excel for storing all types of text data, and who had said he never used mouse clicks to make his elections, it was all done with keystrokes.
I have wriiten some event code which is used to allow the user to enter filter criteria directly in cells in a blank row above the Autofilter line.
There is no need to use the filter dropdowns, or invoke the Custom dialogue.
Full use can be made of the wildacrds "? and "*" in making selections, as well as the ">, "<", "=" operators.
The cell containg the criteria is highlighted in a different colour, allowing easy viewing of which columns have criteria applied
and what those criteria are.
The code works with all versions of Excel from XL97 through XL2007 and also works with the List object of XL2003 and the
Data object of XL2007
A copy of the file has been uploaded to the Download area as FastFikter.xls, and also includes instruction on how to use it.
I hope some people will find it of use to them.