Text Box Linked To Cell
 

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

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
denise Wrote:
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
------------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435
View this thread: http://www.excelforum.com/showthread...hreadid=470792