| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to build DDE link with text from another cell | Excel Worksheet Functions | |||
| Can I link a text box to a cell? | Excel Discussion (Misc queries) | |||
| Hyperlink to link to text, not just a cell | Excel Worksheet Functions | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
| Link cell is truncating text | Excel Worksheet Functions | |||
Linear Mode
