Run macro when SPECIFIC cell is changed
Posted by John on April 05, 2000 4:49 AM
Apologies is this is an obvious question, but I'm fairly new to Excel macros.
I have some code that I need to run whenever Cell A1 is changed.
I've tried messing about with the Worksheet_Change event. I can get it to work when ANY cell is changed, but I need it to run whenever A1 (and only A1) is changed.
I've searched the acrhive and looked at the tips section, but still can't work out how to do this.
A simple explanation would be appreciated!