Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering Variable Text in Text Boxes......
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering Variable Text in Text Boxes......
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering Variable Text in Text Boxes......
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 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering Variable Text in Text Boxes......
On Jun 14, 1:10 pm, "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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
Are there Rich Text Text Boxes | Excel Discussion (Misc queries) | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
clearing text from text boxes | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) |