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

I am wondering if data from a text box in one worksheet can be linked to a
cell in another worksheet. Thank you.

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

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.

"Max" wrote:

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
---
"Jason Boyd" wrote:
I am wondering if data from a text box in one worksheet can be linked to a
cell in another worksheet. Thank you.

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

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
---
"Jason Boyd" wrote:
I am wondering if data from a text box in one worksheet can be linked to a
cell in another worksheet. Thank you.

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

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.

You need vba. Hang around for responses from others.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---