Invoke macro on Autofilter Criteria Selection

[Rafi]

Hi,

Is there an event associated with the selection of an AutoFilter criteria?
I would like to invoke a macro after the user select a criteria from the
AutoFilret drop down associated with column 2 in the worksheet

Thanks

 

[Joel]

You can use a worksheet change event. Compare again the cell in row 1 where
the drop down list is shown

sub worksheet_change(Byval Target as Range)
if Target.address = "$D$1" then

end if

end sub

 

[Rafi]

Joe,

Thanks ofor the reply however, the code does not seem to work on an
AutoFilter. Any other suggestions will be appreciated.