I am trying to automate the creation of a series of textboxes (one for each
page of my workbook - which consists of many pages) that will grab data from
cells on different pages of the workbook and display the information to a
user. This is done interactively. The data in the box has to change
constantly depending on what triggers its display. I got much of this to work
but I am encountering a few problems, which I suspect are simple, but which
I can't resolve.

I enter text in excel cells. But sometimes the text is very long and ought
to be broken down into paragraphs. Is there any way either (1) to enter the
text with paragraph marks embeded so that when it is dumped into the text box
it will look formatted or (2) to bring it the text piecemeal (I can do that)
and add the appropriate marks as it is being read into the textbox (I could
add some character to the text that would allow a program to substitute it
for whatever is necessary.)

I have tried a number of things but none seem to work. It may be that the
root of my problem is that I do not have the text box set to mulitline. I
can't seem to get ".multiline = true" to work (I get a runtime error).

I do not want to create each box manually since there will be very many of
them, and I suspect I will want to change other things as I progres.
Currently I have a macro to do some of that. But I can't seem to get all the
details right.

There are other such issues. But initially, I would greatly appreciate help
in resolving the particular ones mentioned.

Thanks.