Depending on how the cell is changed (typing or calculation), you could tie into
a worksheet event.

Chip Pearson has lots of info:
http://cpearson.com/excel/events.htm



Dewey wrote:

Hi,

I'm trying to run a macro that constantly monitors a file. so that
every time a cell value is added or changed the macro checks for
certain errors.

Is this possible?

Many Thanks

Dwight

--

Dave Peterson