Text Box Linked To Cell

D

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
 
P

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