Entering Variable Text in Text Boxes......

[Steve Jones]

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

 

[Guest]

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

 

[Guest]

Steve,

Put something like this in a cell. Ensure the textbox is Multi-line enabled
and use the cell to populate the textbox.

="Toys"&CHAR(13)&"R"&CHAR(13)&"Us"

Mike

 

[Lacty]

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

I am not quite sure how to do it directly in Excel but here is a
little trick which might achieve same result

In say Cell A5 or any other cell, enter the formula = A1&" " & A2 &"
"&A3. this will concatenate all three values in A1, A2, A3.
Use Cell A5 instead in your textbox. After that reduce the size of the
textbox such that all three values are displayed in seperate lines.

To make the size of the textbox bigger, increase the number of spaces
within the quotation marks in the formula.

Hope this helps.