Textbox limited to 255 characters when linked to another cell

[dwilson38550m]

Hi,

I am having problems populating a textbox in Excel. The textbox (sheet 1) is auto populated from cell A2 (sheet 2) and works fine when the number of characters is below 255 however as soon as the number of characters increases beyond this (255) the end of the text string is truncated.

Text box Sheet 1 'Sheet2'!$A$2
Sheet 2 Cell A2 =R15&CHAR(10)&R16&CHAR(10)&R17&CHAR(10)&R18&CHAR(10)&R19&CHAR(10)&R20&CHAR(10)&R21&CHAR(10)

The reason for using CHAR(10) is so that a new line is used for each piece of information.

I am not running this programme through a macro programme (just a simple cell link). I have tried so many option but is there anything you can suggest - I believe there is a way to increase the number of characters a textbox can allow (but I am not sure how to do this within the text box), data validation?

Thanks in advance for any suggestions,
David

 

[Fluff]

As far as I'm aware it can only be done by either copy & paste or by a macro. For a macro solution have a look here
Copy text from a cell to a textbox more than 255 characters