text box in Excel 2007

S

Simon Minder

Hi all,

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

Kind regards,

Simon Minder
 
S

Simon Minder

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.
 
Top