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
|