Look at the Change event

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

--
Regards,
Tom Ogilvy


"a94andwi" wrote in
message ...

Maybe I need to explain myself a little to make you understand.

I have a sheet that contains default value in cell A1.
This value is out of my system at work and I am trying to tweak the
system and need to try out new values to see what the output will be.

In cell B1 I have the "test cell". This is where I do the tweak input
values.

In cell C1 I have calculations that take the new values in B1 and give
me an idea of what my system will create for values when put these
values into the system.
I do not want to put the figures into the system before I know that it
will not create a disaster. I'm working at an international company and
wrong inputs may cause a lot of damage and cost a lot of money.

I am trying to see what can happen before I actually do it.

This is why I would like the cells B1 to contain the same value as in
cell A1 until I write something in cells B1. If the result is not what
I would like it to be I erase the input in cell B1 and it show the
default value taken from cell A1.

It would be great if this is possible to do to create huge test
environments.

/Anders


--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile:
http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=539247