executing a macro from within a cell
 

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.

executing a macro from within a cell
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


kduntley wrote:
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.

executing a macro from within a cell
 

You'll need an event macro. See

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

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


In article ,
"kduntley" wrote:

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.