| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link text box to a cell
Hi
I have encountered the common problem that when typing a long paragraph(s) in a merged cell with text wrap, that after the 1,000th character text wrap no longer works and you have to hit Alt + Enter after every line. I have the text that gets entered in one cell on a sheet linked to another cell on another sheet via the ='Sheet Name'!Cell # formula. Is there any way I could link a text box instead to the other cell so that I can get around the text wrap issue? Thanks SM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Link text box to a cell
I'm not sure this will solve your problem but you can try it...
Draw the text box... With the text box active click in the formula bar and enter the linked cell address. For example: =A1 -- Biff Microsoft Excel MVP "SM" wrote in message ... Hi I have encountered the common problem that when typing a long paragraph(s) in a merged cell with text wrap, that after the 1,000th character text wrap no longer works and you have to hit Alt + Enter after every line. I have the text that gets entered in one cell on a sheet linked to another cell on another sheet via the ='Sheet Name'!Cell # formula. Is there any way I could link a text box instead to the other cell so that I can get around the text wrap issue? Thanks SM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
| 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) | |||
| 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
