Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linking two cells that are bi-directional misscharliebrown Excel Discussion (Misc queries) 2 September 24th 08 09:47 PM
directional keys go the wrong dir in a text box Jason Merz Excel Discussion (Misc queries) 1 February 24th 08 11:41 PM
How do I set up a Speed and directional graph houndman Charts and Charting in Excel 0 July 2nd 06 03:11 PM
can you do a bi-directional link in excel Mahmoud Hamed Excel Discussion (Misc queries) 1 April 19th 05 10:47 PM
how do I move and activitated cell with a directional key movemen. steve wingate Excel Worksheet Functions 2 December 18th 04 07:20 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"