Run Macro Automatically from entering data into cell

[yunesm]

- When I add data to cell B1 I want a macro to run (below).

- B1 is a drop-down list. When the data is deleted the macro shouldn't run

- When the data is selected or reselect from the drop-down it should run

Please Login or Register  to view this content.

Any help is much appreciated!
Thanks!

[tony h]

The worksheet change event fires after a change but you will need to inspect Target to determine whether you need to run your routine

[yunesm]

This seems to be working for me but now I'm realizing In need to deselect my autofilter if I delete.

Please Login or Register  to view this content.

I'm going to try to add this in once the data in cell B1. I've tried a couple of things with no luck. Again any thoughts would be appreciated.

Please Login or Register  to view this content.

Thanks!

[JBeaucaire]

Maybe just turn it off:

Please Login or Register  to view this content.