I'm not familiar with the Chr() cmd. Would that create automatic line breaks
in the narrative, and how would that affect what the end-user sees? Do you
have a link towards a support article or website that provides more
assistance on this cmd?

Thanks,

Scott

"Harlan Grove" wrote:

"Scott Whetsell, A.S. - WVSP" wrote...
In a workbook that we are using the users enter a narrative into a
userform text box which places it in a cell on it's own worksheet.
The cell is column A and all rows merged, and text wrapping has been
selected. The formatting works correctly for the first 18 lines,
then the text wrapping stops and it just cuts off any additional
text on that line. Line breaks still work, but it will not wrap any
additional text.

You're almost certainly hitting Excel's approximate 1024 character limit on
how many characters it'll display in a cell if there were no embedded
newlines in the text. Your ONLY option is using VBA to embed regularly
spaced newlines (in VBA, Chr(10)) in the text box text before entering it in
the merged cells. In other words, you can't rely on word wrap.