Can a text box use a formula or cell reference

[Joe M.]

I have a chart that I added a text box which I would like to reference a cell
which contains a formula. Suppose cell c25 contains the formula =sum(C2:C23).
Is it possible for the text box to reference cell c25?

Thanks,
Joe M.

 

[FSt1]

hi
a text box from the control toolbox has a linked cell property and will
display the contents of the linked cell.

regards
FSt1

 

[excelent]

Select ur shart
type =c25


"Joe M." skrev:

 

[bala_vb]

I have a chart that I added a text box which I would like to reference
cell
which contains a formula. Suppose cell c25 contains the formul
=sum(C2:C23).
Is it possible for the text box to reference cell c25?

Thanks,
Joe M.

Here is nice example

http://www.exceltip.com/st/Linking_a_Cell_to_a_Text_Box/184.html

all the bes