View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Can a text box use a formula or cell reference

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

regards
FSt1

"Joe M." wrote:

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.