Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Text in Text Box
I have seen a worksheet having Text Box which have linked text values. kindly
some one tell me how I can make a Text box like that which is getting values from one or more cells with in the Sheet or another sheet. thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Text in Text Box
A drawing toolbar / shape textbox ? Select it and enter like
=A1 in Excels formula field. You can do that with many shapes, like callouts. HTH. Best wishes Harald "adeel via OfficeKB.com" <u32736@uwe wrote in message news:85cc5b10e791a@uwe... I have seen a worksheet having Text Box which have linked text values. kindly some one tell me how I can make a Text box like that which is getting values from one or more cells with in the Sheet or another sheet. thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked Text in Text Box
Dear Mr. Harald:
I am unable to understand your response....Perhaps I didnt clear my question. let me again explain. In Sheet 1 there is a a text in cell A1 "We want Mr. ------ as a GM of ----- -" now in sheet-2 I creat a text box using drawing toolbar which is blank, now what will be the procedure to link Sheet1 Cell A1 in that text box in sheet2. Text box should display the text "We want Mr. ---- as a GM of -----" same as Cell A1 Sheet1. Hope it is clear now..... Harald Staff wrote: A drawing toolbar / shape textbox ? Select it and enter like =A1 in Excels formula field. You can do that with many shapes, like callouts. HTH. Best wishes Harald I have seen a worksheet having Text Box which have linked text values. kindly [quoted text clipped - 3 lines] thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200806/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKED TEXT BOX | Excel Discussion (Misc queries) | |||
text box linked to cell | Excel Worksheet Functions | |||
Text in cell is cut off when linked to another WS | Excel Discussion (Misc queries) | |||
Text Box Linked To Cell | Excel Discussion (Misc queries) | |||
Text box linked to datasheet | Charts and Charting in Excel |