Lost Focus apply to cell
 

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

Lost Focus apply to cell
 

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