Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing value in cell with answer of same cell
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing value in cell with answer of same cell
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" "Flying_Dutcman" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions |