Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking two cells that are bi-directional | Excel Discussion (Misc queries) | |||
How do I set up a Speed and directional graph | Charts and Charting in Excel | |||
can you do a bi-directional link in excel | Excel Discussion (Misc queries) | |||
how do I move and activitated cell with a directional key movemen. | Excel Worksheet Functions | |||
Bi-Directional Cell Linking | Excel Programming |