Simple - Add another cell to itslef

**Allusion** · 08-24-2006, 12:20 PM

I have a simple question that I cannot find an answer to (tried searching forums.) I would like to take a currecny value in one cell and add a currency value from another cell to itslef.

Example:
cell A1 = $5.00
cell A2 = $3.00
new value for cell A1 = $8.00

Of course I realize that there is a potential of an infinite loop here but I was hoping that this formula would only run when cell A2 is changed. I am doing data entry to a chart of accounts and I am tired of switching to my calculator then back to excel.

Would variables work better? I can't figure out how to use them

I can't get the variable in the cell.

Thanks.

**Excelenator** · 08-24-2006, 01:33 PM

Place this code in the worksheet VBE object

Please Login or Register  to view this content.

**Allusion** · 08-24-2006, 03:41 PM

Works like a charm

I can't undo if I make a mistake but this will still save me a lot of time.

Thank you very much!

**Excelenator** · 08-24-2006, 07:24 PM

If you make a mistake, say by putting in 3 when you meant to put in 6 you can input -3 then 6. Not really efficient but you can unravel it for one step at least.