Detect Autofilter Change Event

[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

 

[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?

 

[Alan Z. Scharf]

Sheloo,

Thanks very much.

Will post results, probably next week.

Regards,

Alan