Referencing in a text box
 

Hello brainiacs!

I'm sure this is no challenge for you're average IQ's of 165!!

I want to import the data from a cell on anoher sheet into my text box
(you know the text box you can put from the "draw" toolbar!

Thanks in advance guys

--
krhym
-----------------------------------------------------------------------
krhyme's Profile: http://www.excelforum.com/member.php...fo&userid=2522
View this thread: http://www.excelforum.com/showthread.php?threadid=39057

Referencing in a text box
 

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

Referencing in a text box
 

and then of course, press the Enter ke

--
barrfl

Excel User - Energy market
-----------------------------------------------------------------------
barrfly's Profile: http://www.excelforum.com/member.php...nfo&userid=414
View this thread: http://www.excelforum.com/showthread.php?threadid=39057