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

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

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