If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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. 
Ads 
#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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula shows in cell instead of results (text reference)  Dave  Excel Discussion (Misc queries)  1  April 5th 10 11:27 PM 
Reference text in a cell inside a formula to specify a sheet name  navel151  Excel Worksheet Functions  5  February 20th 10 07:47 AM 
Use text in formula as a cell reference  steveylevi  Excel Discussion (Misc queries)  13  July 30th 08 12:09 AM 
reference the result of a formula in a text formatted cell  jpwinston  Excel Discussion (Misc queries)  1  February 7th 05 05:33 PM 
Formula with text and reference to a date cell  [email protected]  Excel Discussion (Misc queries)  1  January 11th 05 08:15 AM 