If it will hold a formula, then you could use the Calculate event to check -
but you would have to use a static variable to record the old variable to run
only when it has changed.

If it will hold a constant value which will be edited by the user, then you
could use the Change event

See Chip Pearson's page on events for an overview
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Dariusz Tomon" wrote:

Hi

I'm wonder if the following sceario is possible:

I have got macro and I want this macro be launched whenever the cell(1,1) =
5 (or when this cell is changed)

Thank you for your proposals.

Best Regards

D.Tomon