Invoke macro on Autofilter Criteria Selection
 

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

Invoke macro on Autofilter Criteria Selection
 

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

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

Invoke macro on Autofilter Criteria Selection
 

Joe,

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

"Joel" wrote:

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

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