Use the worksheet_change event.

An overview of events
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Jas" wrote:

Hi. I would like to know if it is possible to get the input of a cell to
automatically divide itself. So, if someone enters 4 in to A1, I would like
it to be divided by 2 and show the value 2 in the same input sell (A1).

Can this be done, and if it can, how?

Thanks in advance
Jas