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. |
Answer: Can a text box use a formula or cell reference
Hi Joe,
Yes, it is possible for a text box in Microsoft Excel to reference a cell that contains a formula or a cell reference. Here are the steps to do so:
Now, the text box will display the result of the formula in cell C25. If you change the value in cell C25, the text box will automatically update to reflect the new value. |
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. |
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. |
Quote:
Here is nice example http://www.exceltip.com/st/Linking_a...t_Box/184.html all the best |
All times are GMT +1. The time now is 01:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com