Identify code invoked on cell exit / enter - Finde Invoked Code on Cell Exit

Right click on your sheet name at the bottom of excel and select view code

A macro module will open

At the top left there will be a dropdown box. Select "Worksheet"

At the top left there will be a dropdown box Select "Selection Change"

This is the macro module that will run when you select a new cell.

There is another option on the same module for "Worksheet Activate"

So if you declare a public variable to save the active cell address when you activate the sheet then you
will have access to the active cell address and to the previous activecell address.

Please Login or Register  to view this content.