Lost Focus apply to cell

[John]

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

 

[Tom Ogilvy]

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

Look at the Change and SelectionChange events as possibilities.