enter data in cell then run macro automatically
 

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick

Yes.

That type of macro is run from Event code.

For more on events see Chip Pearson's site at

http://www.cpearson.com/excel/events.htm

Or David McRitchie's site at

http://www.mvps.org/dmcritchie/excel/event.htm


Gord Dibben Excel MVP

On Tue, 25 Jan 2005 21:04:42 -0000, "R D S" wrote:

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick

Yes..

http://www.cpearson.com/excel/events.htm


http://www.mvps.org/dmcritchie/excel/event.htm


Regards,

Peo Sjoblom

"R D S" wrote:

Hi,

Is it possible that I can enter data into a cell and then the pressing of
the enter key will cause a macro to run?

Rick