text boxes I ('97)

[tfboni]

Is there a way to have a text box show the contents of two separate cells?
Would I use the "&" or "+" ?
Also, how do I insert a carriage return in a text box?

[pieterse]

A textbox on a sheet can only be tied to a single cell. You'll need to have a formula in a cell that puts together the strings and use that cell as the source for the textbox.

[tfboni]

Now why didn't I think of that?
(Don't answer that!)

How would I force a carriage return in the resulting text box?

[HansV]

You can concatenate with CHAR(10) to insert a line feed:

=A1&CHAR(10)&A2

In the cell containing this formula, the CHAR(10) will look like a box, unless you set the cell to wrap, but in the text box referring to the cell with the formula, it will be a line feed. Alternatively, you can concatenate with " followed by Alt+Enter followed by ". This will insert a line feed directly into the formula itself, making it look weird:

=A1&"
"&A2

[tfboni]

Too much! Thanks.

RELATED:
How do I get an existing text boxes content into a regular spreadsheet cell?
(Right now, I'm doing it manually...via cut & paste...)

[sdckapr]

Either copy/cut and paste or use a line like this in a macro

<pre>Range("a1") = Activesheet.TextBoxes("Text Box 1").Text</pre>


Change the text box name as appropriate

Steve