Hi
use the worksheet_change or worksheet_calculate event for this. See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany

<M.Streeks schrieb im Newsbeitrag
...
How do I trigger a sub when the value of a specific cell changes?

I have a cell based on validation list. When the value cell changes I
need
to run a sub in another worksheet.

thanks,

Mike