Sending values?

bobmc · Mar 14th, 2002, 01:03 PM

Is there a way to SEND a value from one cell to another, overriding anything that may have been entered into that cell?

Mudface · Mar 14th, 2002, 01:06 PM

Not to sure what you mean, but entering =A1 into cell B1 will show always show the value in A1 (or a zero if A1 is empty).

[ This Message was edited by: Mudface on 2002-03-14 12:08 ]

smozgur · Mar 14th, 2002, 01:11 PM

Open VBA editor then double click on the Sheet that you want to apply transferring cell values. And select the Worksheet on module and Change event then write this code there.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then Range("A2").Value = Target.Value
End Sub

to change A2 cell value to A1 value when A1 changed.

regards
suat

[ This Message was edited by: smozgur on 2002-03-14 12:12 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 01:03 PM	#1
bobmc Board Regular Join Date: Mar 2002 Posts: 142	Is there a way to SEND a value from one cell to another, overriding anything that may have been entered into that cell?

Mar 14th, 2002, 01:06 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Not to sure what you mean, but entering =A1 into cell B1 will show always show the value in A1 (or a zero if A1 is empty). [ This Message was edited by: Mudface on 2002-03-14 12:08 ]

Mar 14th, 2002, 01:11 PM	#3
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Open VBA editor then double click on the Sheet that you want to apply transferring cell values. And select the Worksheet on module and Change event then write this code there. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address = "$A$1" Then Range("A2").Value = Target.Value End Sub to change A2 cell value to A1 value when A1 changed. regards suat [ This Message was edited by: smozgur on 2002-03-14 12:12 ]