u can do. first mer ge all cell to any other cell and give that cell address
to text box

eg: D1: =A1&CHAR(10)&B1&CHAR(10)&C1
then text box: =D1

pls dont worgat for rating

thx


"Steve Jones" wrote:

I have some information in cells A1,A2 & A3.

Is it possible to get all the information to appear in a text box on three
different lines?

I can get the contents of cell A1 to appear in the text box, but I would
like the contents of A2 to appear on another line and A3 on a third line in
the same box.

If not a Text box could it be done in Comments?

Thanks