Hello,

I am trying to create a macro that copies and pastes the resultant text of a
column of vlookups into a text box(shape). The text returned can be rather
lengthy, and not all the cells will necessarily return their text all the
time.
My question is, is it possible to overcome the 255 character string
limitation in VB in order to copy and paste all the text from a cell into the
text box before moving on the the next cell? I would also like the text from
a new cell to appear on a new line, and blank cells not to appear at all. Is
this possible?

Thanks,

Alan Lueke