Gordon

You could swap the Textbox for a RichTextBox which will allow you to paste
the text from word (via the clipboard) with the carriage returns in place.

You can get the RichTextBox by rightclicking the Toolbox and selecting
Additional Controls. Check Microsoft Rich TextBox Control (version 6.0 in
Excel 2002).

Hope this helps
Rowan

"Gordon" wrote:

I have a textbox control on a user form that needs to contain several
paragraphs of text. I have these paragraphs in a rich text file edited and
saved in Word. I would rather not do this in VBA code, because the text
never changes and really should be permanently stored with the textbox. Two
years ago I somehow was able to get all these paragraphs of text into the
textbox control, and I did so without using VBA code and without typing the
text into the text slot of the textbox's property window in VBA, which anyway
will not take carriage returns. It does not work to copy the text from the
rich text file to the clipboard and paste into the text slot in the property
window - only text up to the first carriage return is pasted.

Any suggestions?