enter value to cell, it will calculate and enter result to another cell

[Rocky2013]

Hello,

E15 = 535,000
D18 cell format in $
D19 cell format in %

Enter a 53,500 in D18, then D19 will show a result of 10% (D18/E15)
Enter 15% in D19, then D18 changes to $80,250 (E15 * D18)

Cell D18 and D19 corespondent each other, enter a value in one cell,
the value in other cell will change.

Thanks

[Croweater]

Please Login or Register  to view this content.

[Artik]

And me, with a muzzle.

Artik

[Rocky2013]

Hi, Croweater

Is there a way to run real time calculate to update D18 after 10% typed in D19 without moving the cursor to a different cell or press ENTER to update?

Example:
When I type a 1% in D19, then D18 shows $5,350.
If I continue to type 0 after 1 then D19 becomes 10%, D18 changes to $53,500
If I move the cursor to a D20, means this will be more entry to end the VBA.


Thanks

[Rocky2013]

And me, with a muzzle.

Artik

Hii,
Can D18 in real time update the calculation after 10% type in D19?

Thanks