View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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