Home 
Search 
Today's Posts 
#1




Can a text box use a formula or cell reference
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. 
#2




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. 
#3




Can a text box use a formula or cell reference
Select ur shart
type =c25 "Joe M." skrev: 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. 
#4




Quote:
Here is nice example http://www.exceltip.com/st/Linking_a...t_Box/184.html all the best
__________________
Thanks Bala 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Formula shows in cell instead of results (text reference)  Excel Discussion (Misc queries)  
Reference text in a cell inside a formula to specify a sheet name  Excel Worksheet Functions  
Use text in formula as a cell reference  Excel Discussion (Misc queries)  
reference the result of a formula in a text formatted cell  Excel Discussion (Misc queries)  
Formula with text and reference to a date cell  Excel Discussion (Misc queries) 