VBA to assign preset formulas to cells but allow input value

[NewUser2]

Hi So I am wondering if there is an easy way to assign preset formulas to cells having it so,,, for example I could have something like = __ +35. The goal is that when someone types a number into that cell, it will automatically add 35 to whatever number they typed in.

The kicker is that I need this all to occur in One cell. It can't use two, that would be easy (just have A1 blank, then B1 =A1+35 and have the person enter their number in A1).

Is this possible? If I had it set up as VBA code for my worksheet.

Thanks!

 

[oldbrewer]

you need something like if the cell in question changes then the macro immediately adds 35 to the cell

maybe around on cells(1,1).update then call macro1

 

[NewUser2]

That sounds like it could be good. I don't really know much/anything about VBA.. could you please clarify?
Is 'around on cells' a command?

Thanks!

you need something like if the cell in question changes then the macro immediately adds 35 to the cell

maybe around on cells(1,1).update then call macro1

 

[oldbrewer]

no -- by around I meant something like this

google EXCEL run macro when specific action occurs