Link a text box value to a cell (reverse)

[Jiovannos]

Hello all,

I have the following problem. I would like to link the contents of a textbox (which are numbers) to a cell so i can change the contents of the TEXTBOX and give me that number on the CELL.Not the reverse.
The problem is I have a great range of drawing lines that have a textbox next to them showing their length. They are all in the boundaries of a single cell. I want to write the contents of the textbox to a nearby cell so i can add or substract the lengths.
So I ll make it more clear with an example: In the bountaries of the cell A1 there is a line and a textbox below the line with the number 700 inside (which means that the length of the line is 700 mm). I want to plot this 700 to the cell B1, and if i change 700 to 500 , B1 would have to change too. The same with A2-B2, A3-B3 etc. I have nearly 500 lines with textboxes so I can't afford to write the name of each textbox separetely.

If the above is possible as second task I would like to add all textboxes values that are in the boundaries of cell A1 to cell B1. (sometimes there are 3 lines and 3 textboxes in a cell)

I would very much appreciate your help.
Thanks in advance,
John

 

[Andrew Poulsom]

Welcome to MrExcel.

What you are doing seems very complex, but if you use TextBoxes from the Control Toolbox (ActiveX) you can set the LinkedCell property. Note that it is bidirectional.

 

[Jiovannos]

Thank you, active x textbox looks fine but now i can't get this right: when i copy the row with the textbox in, or just the textbox, it is linked to the same cell, not to the pasted reference cell, as with regural excel copy paste. Ex. If i have a textbox on A1 linked to B1, if i copy all the "1" row and paste it below, I want to link the new textbox (which is now at cell A2) to the cell B2, etc without doing it manually in each and every one.
Can you see that happening?

 

[Andrew Poulsom]

The Linkedcell property is just a string, so it won't be changed relatively when you copy the control, I'm afraid.