Worksheet change AFTER selection change

I'm trying to fire a macro with selection changes.
I've tried the two methods below (I think these are applicable with Class Modules).
The first method gives me issues ... long story.
The second method fires when a cell is selected. I want it to fire after I leave the cell. Is there any way to do this?

Please Login or Register  to view this content.

You would need to use a static variable declared a workbook (needs to be in a standard module) level to store the range of the previous cell.

Set the varaible = activecell in a workbook open event and worksheet activate event.

Set the variable = target at the end of your change / selection change code.

Remember to use a command such as Intersect to compare the cell stored in the variable to the cells where it should run in order to prevent it misfiring.

Thanks for responding. But how to do with code?

In a standard module.

Please Login or Register  to view this content.

In the 'ThisWorkBook' module.

Please Login or Register  to view this content.

In the worksheet module.

Please Login or Register  to view this content.

At the start of your existing code (this is to run it only on A2:A100, change as needed).

Please Login or Register  to view this content.

At the end of your existing code (before End Sub)

Please Login or Register  to view this content.

You might need some changes / additions. That's best I can do with the information in your question.

Thanks, this seems to have worked.