Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change/set pivot table autofilter criteria with macro button | Excel Discussion (Misc queries) | |||
Selection.AutoFilter Field / Criteria = criteria sometimes non-existing on worksheet | Excel Programming | |||
macro stops on "selection.autofilter" line of code | Excel Programming | |||
Invoke a macro with the Enter key | Excel Programming |