Hi,
Yes, you are correct. Though I don't know VBA. Please explain me how to
accomplish my request. Suppose a container holds 2000 cartons and 5
containers equal how much. So, when i enter 5 the result will be 10,000..
Just out of curiosity I am looking for this..

Thanks..john britto

"AlfD" wrote:


Hi!

But you can if you use VBA.

Is this what you want?

Example: A1 holds 1000.
You click on A1 and enter 2
A1 now shows 2000

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=474318