What sort of textbox, control toolbox or userform? Multiline should work,
and add Alt-Enter, or Chr(10) should give you the breaks.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"eugene" wrote in message
...
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.