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
|