Worksheet_Change/SelectionChange: Detect if a has a filter caused the change?

[brucemc777]

I have a procedure in the Worksheet_SelectionChange.

I see that if I go over and re-sort the table on that worksheet, the event is triggered and the code runs.

I want to know if the WorkSheet_SelectionChange event is triggered by the user clicking a different item in the table, or if it was caused by imposing some filter.

The reason is that IF a specific userform is open I need to completely reset that form ONLY if a filter has been invoked; otherwise, the form has it's own mechanism to reflect changes in the table. If the table has been filtered, the comboboxes need their lists reset to match the table.

Is there a way to trap this?

Thank-you!

edit: As additional information, I have tried toying with the autofilter and autofilter properties(?) of the worksheet, but they do not trip if all that has been done is the user "simply" sorted the table in another order; i.e., ascending vs. descending. I suppose the working answer for now is to check autofilter and autofiltermode AND whether the same value is still in cell A1, but not only does that seem to me rather, well, lame, but also I suspect it won't always work-

[dflak]

Take a look at target.address. If it is the filter cell, then do A, if not do B.

[brucemc777]

Thank-you!

I see now that if I change the cell a cell address is reported back by target.address, but if the filter is used to re-sort, a multi-cell range is reported back. That is very helpful!