need help

[Don Juan]

I was wondering how I would allow a cell to not only display a value from another cell but switch its value to represent another cell if a value were inputed into that alternate cell. for ex:

a1 =1+1 b1 displays 2 but then i type into a2, 2+2 b1 now displays 4. b1 removed its association temporarily from a1 to a2. I would like to do this all the way down to a9, so that b1 would read whatever the last inputed number was in the a column. Also I need to set it up so that when you type a value into more than 1 of the a cells you are prompted to either add the two values a1+a2 to store in b1 or to just display a2 by itself, or whatever the last inputed number was. I want to give the user that option. Can anyone help me?

thanks to all that spend time helping others understand this program better. It can be a little overwhelming sometimes.

[davesexcel]

another bleeding macro,

worksheet module when there is a change in column A
the new value is entered into B1

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
ActiveCell.Offset(-1, 0).Range("A1").Select

Range("B1").Value = ActiveCell
End If

End Sub

[Don Juan]

what do I put in box b14 (the box displaying the g column) when I use the macro? b14 will change according to the last g column value entered right? So what formula goes into b14?

[davesexcel]

....a1 =1+1 b1 displays 2 but then i type into a2, 2+2 b1 now displays 4. b1 removed its association temporarily from a1 to a2. I would like to do this all the way down to a9, so that b1 would read whatever the last inputed number was in the a column.....
This code works how you asked, when you enter a value in Column A the value shows in Range B1,
Why enter =1+1 when you could enter 2

Alter the code Column A is Column 1 in the code change the column number as you require and the range to be displayed

[Don Juan]

I still dont know what to put into the box thats displaying the altered info. THis box I have designated b14. The column doing the changing is G3:g9. Anyone of these will display in b14. What formula do I put in b14? I typed the code exactly as you said. It has no errors but its not doing anything.

[davesexcel]

Okay Don Juan,

This will work the way you want, when you change a value in Range G3:G9
the value will show in B14

Look at the code, you can change the ranges as you require

Private Sub Worksheet_Change(ByVal Target As Range)

If Union(Range("$G3:$G9"), Target).Address = Range("$G3:$G9").Address Then

Range("B14").Value = Target.Value
End If

End Sub

[Don Juan]

yes, but what goes in box b14? Any code? do I leave it empty? cuz its not displaying nothing when I do that? SHould I put something like =g3:g9 etc.? The code you gave me I understand. Whats confusing me now is what goes in b14.