enter data in cell then run macro automatically

[R D S]

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

 

[Gord Dibben]

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

 

[Peo Sjoblom]

Yes..

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


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


Regards,

Peo Sjoblom