How to make a Macro run after every cell adjustment
 

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

How to make a Macro run after every cell adjustment
 

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

How to make a Macro run after every cell adjustment
 

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