Displaying Autofilter Formula

  • Thread starter Thread starter Michael.Tarnowski
  • Start date Start date
M

Michael.Tarnowski

Hi community,
for worksheets with a lot of columns and therefore a lot of
AutoFilters possible, is there a way to display the resulting formula
being effective in filtering in the status bar?
Cheers Michael
 
Hi,

Do you mean can you display the criteria? There is nothing built-in to
Excel to allow you to do this. It might be possible with VBA but I'm not
sure.
 
Hi Michael

There is no inbuilt method.
Take a look at a file I created called FastFilter, where you type what you
want in the row above the filter.
Any columns which have a filter set, have the cell in row 1 coloured, and
the criteria you set are visible.
A copy of the file can be downloaded form
http://www.contextures.com/Fastfilter.zip
 
Hi Michael

There is no inbuilt method.
Take a look at a file I created called FastFilter, where you type what you
want in the row above the filter.
Any columns which have a filter set, have the cell in row 1 coloured, and
the criteria you set are visible.
A copy of the file can be downloaded formhttp://www.contextures.com/Fastfilter.zip
Click to expand...

Hi Roger, hi Shane,
I found in the net two VBA solutions:
http://www.j-walk.com/ss/excel/usertips/tip044.htm
http://www.ozgrid.com/VBA/autofilter-criteria.htm

Both display the filter criteria in a cell, I'am looking for a status
line message.
Any ideas?

Cheers Michael
 
Hi Michael

There is no inbuilt method.
Take a look at a file I created called FastFilter, where you type what you
want in the row above the filter.
Any columns which have a filter set, have the cell in row 1 coloured, and
the criteria you set are visible.
A copy of the file can be downloaded formhttp://www.contextures.com/Fastfilter.zip
Click to expand...

Hi Roger, hi Shane,
I found in the net two VBA solutions:
http://www.j-walk.com/ss/excel/usertips/tip044.htm
http://www.ozgrid.com/VBA/autofilter-criteria.htm

Both display the filter criteria in a cell, I'am looking for a status
line message.
Any ideas?

Cheers Michael
 
Back
Top