Run Macro on Enter Key if Address = A1

[carsto]

Is there a way to call a macro (or just run a few lines of command) if the user hits Enter while the ActiveCell is A1

edit:
Actually, the code I'm trying to run doesn't work right itself.
This is the jist of what I want to do.

Please Login or Register  to view this content.

what happene to the code icon?

[foxguy]

Hi carsto;

Here's 2 ideas off the top of my head.

1) If the value in A1 changes EVERY time the use hits ENTER, then you can use the Worksheet_Change() event to run the macro.

2) If the value doesn't necessarily change, then use the the Worksheet_SelectionChange() event to store the address of the selection and check it every time to see if the cell it's coming from is A1.

Please Login or Register  to view this content.