can you link a text box to a cell in excel?

  • Thread starter Thread starter Jason Boyd
  • Start date Start date
J

Jason Boyd

I am wondering if data from a text box in one worksheet can be linked to a
cell in another worksheet. Thank you.
 
You can go from a cell to a text box, but I want to go from a text box to a
cell or range of cells.
 
Looks like its possible ..

In Sheet2,
I drew a text box,
clicked to select its borders (or press F2),
then placed into the formula bar, say: =Sheet1!A1
then clicked out of the text box

And the text box would display the contents of Sheet1's A1
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Linking a workbook to worksheets 1
Worksheet linking 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Link text box to a cell 1
Link cells with text not numbers 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top