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.