View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Bi-Directional Cell Linking

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