Link text box to a cell

S

SM

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
 
T

T. Valko

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
 

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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Cell data entering slow! 0
Select Text to End of Footnote 9
Wrapping and Anchors 0
Excel does not accept text format! 0
Paste Link and Link Text From Browser to Word 0
Link a text box based on drop down box with four options MS Word 365 0
Clearing combo boxes and a text box 2

Top