1.highlight the text box
2.go to the formula bar
3.put and equal sign (=) and then reference the cell that contains the
data that you want to appear


--
barrfly

Excel User - Energy markets
------------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...fo&userid=4141
View this thread: http://www.excelforum.com/showthread...hreadid=390577