Replacing value in cell with answer of same cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Flying_Dutcman - 21 Jul 2006 09:08 GMT

I need to replace the value in A1 with the entered value in B1. eg, A1=20;
B1=20 now I type 30 into B1 and A1=50. Is this at all posibble? Please help?

Reply to this Message

Muhammed Rafeek M - 21 Jul 2006 09:33 GMT

Hi
Try this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then
Range("A1").Value = Range("A1").Value + Range("B1").Value
End If
End Sub

you have to write this code to "Work sheet module"

> I need to replace the value in A1 with the entered value in B1. eg, A1=20;
> B1=20 now I type 30 into B1 and A1=50. Is this at all posibble? Please help?

Reply to this Message