ExcelBanter - View Single Post - How to make a Macro run after every cell adjustment

Dewey

Thanks for that Dave.

Dewey

Dave Peterson wrote:

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