| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I enter cell value automatically to textbox?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I enter cell value automatically to textbox?
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 "Fadzil" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I enter cell value automatically to textbox?
Another way. Create the textbox or other symbol. In the formula bar enter
(for example) =$A$1. Works like a charm. HTH "Fadzil" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to enter data then move automatically to new cell? | Excel Discussion (Misc queries) | |||
| What do i enter in the server textbox to access olap? | Excel Discussion (Misc queries) | |||
| Need VBA code to enter text into a textbox !!!! | Excel Discussion (Misc queries) | |||
| enter data in cell then run macro automatically | Excel Discussion (Misc queries) | |||
| How do I get Excel to automatically enter the contents of a cell . | Excel Discussion (Misc queries) | |||
Hybrid Mode
