Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Trapping Autofilter eventPosted by Manish Deliwala on August 17, 2001 9:51 AM
I am amatuer, and am using Autofilter to focus on cells
of interest. Is there a way to trap autofilter event
in VBA - i.e. when user changes the criteria.
Re: Trapping Autofilter eventPosted by Damon Ostrander on August 17, 2001 10:35 PM
There is no specific event defined for a filter object, but you can trap a filter change because a filter change triggers the worksheet's calculate event (Worksheet_Calculate). In this event routine you can then test to see if the filter criteria has changed using the filter's Criteria1 and Criteria2 properties, and the On property that indicates whether the filter is active or not.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.