Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

Trapping Autofilter event

Posted 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 event

Posted by Damon Ostrander on August 17, 2001 10:35 PM
Hi Manish,

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.

Happy computing.

Damon


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.