That's correct.

Will Fleenor wrote:
Thanks, that works but apparently you can only build references to a single
cell and can not build a formula. Ex. you can have =A10 but not =A10+B10.
Is this correct?
Thanks, Will
"Debra Dalgleish" wrote in message
...

A text box can contain a cell reference --

Enter the formula in a cell on the worksheet
Create a text box.
Click on the text box to select it
Click in the formula bar, and type an equal sign
Click on the cell that contains the formula
Press the Enter key

Will Fleenor wrote:

I have heard you can put string arithmetic formula in text boxes. How do
you do this? For example I would like to add the contents of three cells
as follows:
=B1&DOLLAR(B3,2)&B2
Thanks Will


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html