Rocky,
You can use the Worksheet_Change event procedure to do this. Put the
following code in the code module for the appropriate worksheet.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Select Case Target.Address
Case "$A$1"
Range("B1").Value = Range("A1").Value
Case "$B$1"
Range("A1").Value = Range("B1").Value
Case Else
End Select
Application.EnableEvents = True
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"Rocky Bryant" wrote in message
...
Hello,
Is there a way for me to link cell A1 and B1 together
such that when user inputs 10 into A1, B1 = 10. AND when
user input 25 into B1 then A1 = 25?
thanks for any help or advice...
Rocky