ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Starting a macro by changing autofilter criteria (https://www.excelbanter.com/excel-programming/418747-starting-macro-changing-autofilter-criteria.html)

kativa

Starting a macro by changing autofilter criteria
 
Is it possible to start a macro by changing a filtering criteria?

Mike H

Starting a macro by changing autofilter criteria
 
Hi,

Filtering calls the worksheet_calculate event so

Private Sub Worksheet_Calculate()
MyMacro
End Sub

Mike
"kativa" wrote:

Is it possible to start a macro by changing a filtering criteria?


kativa

Starting a macro by changing autofilter criteria
 
Thank you very much! Is there a way to make this work only when one special
column is filtered?



"Mike H" kirjoitti:

Hi,

Filtering calls the worksheet_calculate event so

Private Sub Worksheet_Calculate()
MyMacro
End Sub

Mike
"kativa" wrote:

Is it possible to start a macro by changing a filtering criteria?



All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com