Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Wrap text ceases to function in Excel if cell exceeds 9 lines | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Text in cell as Formula | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |