Detect Autofilter Change Event

A

Alan Z. Scharf

Hi,

I want to detect the autoFilter criteria change event in order to execute
some code after criteria are changed.

Can someone help with the code for detecting the event?

Thanks.

Alan
 
S

Sheeloo

From http://www.mrexcel.com/archive/Data/27590.html
thanks to Damon Ostrander

"There is no specific event defined for a filter object, but you can trap a
filter change because a filter change triggers the worksheet's calculate
event (Worksheet_Calculate). In this event routine you can then test to see
if the filter criteria has changed using the filter's Criteria1 and Criteria2
properties, and the On property that indicates whether the filter is active
or not."

Let us know how it goes... Can you paste your completed code for our benefit?
 
A

Alan Z. Scharf

Sheloo,

Thanks very much.

Will post results, probably next week.

Regards,

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top