hello All I need help with some VBA

[cyote101]

I need a VBA code that will go into the "Page Code" area and will do the following

when someone sellects cell "A1" the value in cell "A1" will be copied to cell "B1". Well that's it.

thankyou all very much

 

[Datsmart]

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

Add this code to the worksheet module you want the code to run in.
Right click the Sheet Tab, choose View Code, paste code in the right side panel.

 

[steve case]

Follow this link:

http://www.mrexcel.com/board2/viewtopic.php?t=180949&highlight=

I asked and answered and got answers similar to what you're looking for.

Hope that helps!