executing a macro from within a cell

[kduntley]

I'm trying to cause a macro to execute as soon as a value in a cell changes. I have not been able to find a way to do it directly or to identify a simple work arround. any help would be greatly appreciated.

 

[Frank Kabel]

Hi
you need an event procedure for this (e.g. use the worksheet_change
event for this). See
http://www.cpearson.com/excel/events.htm

 

[JE McGimpsey]

You'll need an event macro. See

http://www.mvps.org/dmcritchie/excel/event.htm

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