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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Implement a global variable to track the current cell that is active. Update it each time the selection changes in the Selection_Change event. You can then fire off code each time a particular cell is modified and take appropriate actions based on which cell it was that just got edited.