ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   text box in Excel 2007 (https://www.excelbanter.com/excel-worksheet-functions/179749-text-box-excel-2007-a.html)

Simon Minder

text box in Excel 2007
 
Hi all,

Is it possible to add a formula in to a text box ( Ribbon: Insert Text
box)?

Kind regards,

Simon Minder

Simon Minder

text box in Excel 2007
 
To link a cell to a Text Box object:

1. From the Drawing toolbar, click Text Box.
2. Select the Text Box, and press F2.
3. In the Formula Bar, create a link to a cell by typing = and then
selecting the cell.
The contents of the cell are displayed in the Text Box.

"Simon Minder" wrote:

Hi all,

Is it possible to add a formula in to a text box ( Ribbon: Insert Text
box)?

Kind regards,

Simon Minder



All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com