Thanks in advance
Tomasz

See Chip Pearson's page on Events.

You would look for the Change event I would think

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Demian" wrote in message
...
Thanks in advance
Tomasz

First, Subject line is for a subject, put your question in the main text body.



Put the macro in the worksheet Module and use


Private Sub Worksheet_Change(ByVal target As Excel.Range)
if target.address = "Celladdress you want to change" then

'code to run here

end if
end sub
--
When you lose your mind, you free your life.


"Demian" wrote:

Thanks in advance
Tomasz