Text Box Linked To Cell

[denise]

My goal is to have a text box that displays the contents of a particular
cell. How do I link the text box to the cell?

Thanks,
Denise

[Piranha]

Hi denise,

Make a Text Box from the drawing toolbar.
Select the box and in the Formula Bar, type = and
then select the cell, press enter. ( IE: =$C$5 )
The cell can also be on a different sheet, just do the same. ( IE: =Sheet2!C5 )


Dave

My goal is to have a text box that displays the contents of a particular
cell. How do I link the text box to the cell?

Thanks,
Denise