right click sheet tabview codeinsert this. Now if you put 1 in cell b1 you
get 5 in cell b1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$B$1" Then Exit Sub
Application.EnableEvents = False
Target = Target + 4
Application.EnableEvents = True
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bbhart" wrote in message
...
Yeah... sorry... I should have been more specific. That's exactly what I'm
trying to do.

"Jim Thomlinson" wrote:

Not just 100% sure what you want to do. Are you wanting to put a formula
in
Cell A1 such as =4+x and then in cell A1 type a 3 and heve the cell value
automatically be 7... or are you wanting something else entirely.
--
HTH...

Jim Thomlinson


"bbhart" wrote:

How do I make a formula with a variable (ex. 4+x), and make is so when
I type
in a number into that cell it puts that number in as the variable? Is
this
even possible? Thanks for your help in advance cause this problem has
taken
way too much of my time already!