Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
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.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
|
|||
|
|||
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) |