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