View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Boyd[_2_] Jason Boyd[_2_] is offline
external usenet poster
 
Posts: 1
Default 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.