Look at Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

Look at the Change and SelectionChange events as possibilities.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Hi Everyone,

Is it possible to enter some data in a cell and when this cell is not
active, some macro code runs? How should I start declare the sub or what
trick to do regarding this cell 's statement during the macro code, in
order
to make this event happen?

Thanks

John