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

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" wrote:

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

Sheloo,

Thanks very much.

Will post results, probably next week.

Regards,

Alan


"Sheeloo" <Click above to get my email id wrote in message
...
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" wrote:

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