how do I enter cell value automatically to textbox?

[Fadzil]

I have an embedded map into my excel and had inserted a textbox but now I
want to link the textbox to a cell in the other worksheet. How can I do that
? I want the textbox to show the value of that cell automatically.

Thanks in advance.

Have a nice day.

Fadzil

 

[FSt1]

hi
in design mode, right click the text box, select properties.
set the link cell property to the address of the cell ie
sheet2!A2 or whatever your celll address is.

Regards
FSt1

 

[pdberger]

Another way. Create the textbox or other symbol. In the formula bar enter
(for example) =$A$1. Works like a charm.

HTH