How do I link Text Boxes to Cells, not Cells to Text Boxes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2003 and trying to link text enterd in a text box to either
another text box on another tab or a set of merged cells. I do not want to
have to copy and paste nor move the text box once it is filled in. The only
information I can find thus far is how to tie the information entered into
the cells back to the text box (which works great, by the way), but is
opposite of what I an trying to accomplish. Can this be done?
 
You'll need to use the Text Box found on the "Control Toolbox" toolbar rather
than the one found on the "Drawing" toolbar. Then, right-click the text box,
and select "Properties". You should see a field for "LinkedCell". Fill in
your cell reference there.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link text box to a cell 1
Text box does not populate linked cell 2
How to concatenate cell & text in a text box? 3
Copy and move check box (check boxes) with new cell link? 1
text box linked to cell 1
can you link a text box to a cell in excel? 3
How do I use the value in a text box to change a cell value? 3
Copy from a Cell to a text box. 9

Back
Top