Run VBA when a filter is put on data

[penfold1992]

Hello All,

I know that I am able to detect if a change has been made via:

Please Login or Register  to view this content.

but can I detect if a filter has been applied and run vba from it?

[Leith Ross]

Hello penfold1992,

VBA can only detect changes made to cells directly from the keyboard. Changes made by Excel itself like formula calculations, filtering, etc. are invisible to VBA.