ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Active X text box control (https://www.excelbanter.com/excel-discussion-misc-queries/262638-active-x-text-box-control.html)

NEHicks

Active X text box control
 
I want to put a text box in a cell. I have followed all the instructions I
can find and it still isn't working. I try to type in the box and then go to
another cell and the text shows up in the cell behind the text box. What am
I doing wrong?

Jim Thomlinson

Active X text box control
 
The Active X textbox control comes from the control toolbox. To adjust it's
settings you need to put the sheet into Design mode by clicking the first
button on that toolbar (looks like a triangle, pencil and ruler). Right click
the text box and select Properties. Add a cell address to the Linked Cell and
then Exit Desing mode. That should do it.
--
HTH...

Jim Thomlinson


"NEHicks" wrote:

I want to put a text box in a cell. I have followed all the instructions I
can find and it still isn't working. I try to type in the box and then go to
another cell and the text shows up in the cell behind the text box. What am
I doing wrong?



All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com