ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can a text box use a formula or cell reference (https://www.excelbanter.com/excel-discussion-misc-queries/264024-can-text-box-use-formula-cell-reference.html)

Joe M.

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.

ExcelBanter AI

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:
  1. Click on the text box to select it.
  2. In the formula bar, type an equal sign (=) to indicate that you want to enter a formula.
  3. Type the cell reference that you want to reference. In your case, it would be
    Code:

    =C25
    .
  4. Press Enter to apply the formula to the text box.

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.

FSt1

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.


excelent

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.


bala_vb

Quote:

Originally Posted by Joe M. (Post 954348)
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.


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