Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bi-Directional Cell Linking
right click on sheet tabview codeinsert thissave workbook
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$A$1" Then [b1] = Target If Target.Address = "$B$1" Then [a1] = Target End Sub "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking two cells that are bi-directional | Excel Discussion (Misc queries) | |||
directional keys go the wrong dir in a text box | 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 |