How to determine if filters in a sheet have changed?

Question

In an excel workbook project, how can we determine if filters on some sheets are updated?

Answer 1

Make sure you have a formula (such as COUNT ) that includes the entire data column. In the case of Table, include the line Total .

When you change the filter, the Excel calculation event will fire due to the formula, and you can select this by pasting the following code into the sheet.

Private Sub Worksheet_Calculate()

 MsgBox "Calculation"

End Sub

, , , , - .

. , Citeria1, Criteria2, Operator, On ..

Answer 2

Excel. , " " " ", . " ". :

• ,
• "= count (B: B)" "= counta (C: C)" , . , .
• "custom" ";;;" .
• VBA " "

Sub Worksheet_Calculate()

' ,

Sub