Linking a text box

  • Thread starter Thread starter jgz45
  • Start date Start date
J

jgz45

Can you link a text boxt from one sheet to another in excel 2003 and if so,
how?
 
jgz45 said:
Can you link a text box from one sheet to another in excel 2003 and if so,
how?
Click to expand...

Draw a textbox in Sheet1
With the box selected,
click inside the formula bar,
enter, say: =Sheet2!A1
The box will show the contents of Sheet2's A1

---
 
With a cursor in the text box, click in the formula bar, type =, then switch to the target
sheet, click the cell, and press Enter.
 
You must log in or register to reply here.

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

Passing info into a text field when doing the update query 2
Print Area to include text box 10
Excel links 1
set focus method 3
LINKED TEXT BOX 2
Hyperlinking Cells 3
how do I "wrap text" in a combo box 1
Paste Special text or Unicode Text 3

Back
Top