cell formula default

[bsb2013]

Lets say that I want column A+ column B to always equal 2, so if I enter 0 in b1 then A1 becomes 2 then if I change A1 to 1, b1 becomes 1. Is there a way to do this without vba?

 

[mvptomlinson]

Nope.

 

[bsb2013]

any one have vba tips for this then?

 

[mvptomlinson]

Use the Worksheet_Change event, and check to see if cells A1 or B1 changed. If so, change the other one. (Remember to disable events in the code, otherwise you'll create a never-ending loop of change events.)

 

[bsb2013]

Is there any vba-free-way of making a cell default to a formula?

 

[mvptomlinson]

Nope.

 

[VoG]

Maybe Yes. Tools > Options > Calculation > Set Iterations = 1

 

[mvptomlinson]

VoG, the user wants to be able to type a number into a cell that already has a formula and maintain that formula, which I'd love to see an example of without using VBA.

In A1 if you have:
=2-B1

And in B1 if you have:
=2-A1

You create a circular reference, which can be accommodated using iterations, yes. However you cannot overwrite A1 and expect the formula in A1 to re-appear if you then change B1 without VBA.

 

[VoG]

OK , I think I misunderstood,