Hello all,

I have been searching for a solution for a long time but to no avail.
I have a complex workbook with multiple sheets. When a startup macr
is run it connects to my sql server and retrieves the relevant data.
My problem is this: One of the fields that is retrieved has more tha
255 characters in it. It is a synopsis of proposals. It sometimes ha
up to 5000 characters. The query, run by the macro, retrieves all of th
data regardless of string length. I need a way to copy or link thi
cell to another sheet where the text will be autoformatted.
currently have a textbox where I made the end user manually copy th
text but now the demand is for it to be automated. Does anybody hav
any ideas at all?

I have done a straight control source link on the textbox to th
appropriate linked cell, but it only displays 255 char. I have tried
macroed copy paste but if more than 255 char it causes an error. I a
at a loss now. Hopefully, somebody will have an idea or figure ou
what I am doing wrong. As always, thank you for your time in advance.

Mar

--
Message posted from http://www.ExcelForum.com