View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gordon[_2_] Gordon[_2_] is offline
external usenet poster
 
Posts: 211
Default Getting paragraphs of text into a textbox control

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?