See Chip's explanation of Event Macros, specifically the
Worksheet_Change() event example at the end:

http://cpearson.com/excel/events.htm

In article ,
Brendan Vassallo wrote:

I have a macro that I want to run when the valu in a cell is changed. Is
this possible?