I believe you'll need to set the properties of your text box. In design
mode, right-click on your text box and select Properties. Then, Enable
WordWrap and Multi Line.

HTH,
Paul


"AJL" wrote in message
...
Hello,
I am trying to copy and paste the text returned by several vlookup
formulas
to a text box. The amount of text returned to the cells is quite large.
When I set the text box equal to one of the cells, only a portion of the
text
appears in the text box. When I set it equal to a range of cells I get
nothing. Is it possible to generate a macro that will copy and paste
large
amounts of text that result from numerous equations into a text box?
Thanks.

-Alan Lueke