ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text box (https://www.excelbanter.com/excel-programming/301222-text-box.html)

Rich Cooper

Text box
 
Heres the siuation. I have a colum of names, and i have alittle form with
some label boxs and a text box. The text box displays the name. I want to
be able to use the text box as a search function aside from just displaying
a name. So in other words i have a list of names and a text box. I want
you to be able type the name and it to auto complete as you type the name.
So say you have a list of 3 names: cooper, rich; cooper steven; smith, joel;
in the text box i have typed "smi" and it auto completes to smith, joel.
Can this be done and if so how?



Harald Staff

Text box
 
Hi Rich

Sure. All it takes is a little VBA coding. But try first a ComboBox, it
behaves like this on its own and you can pick from its list with keys or
mouse.

HTH. Best wishes Harald

"Rich Cooper" skrev i melding
...
Heres the siuation. I have a colum of names, and i have alittle form with
some label boxs and a text box. The text box displays the name. I want

to
be able to use the text box as a search function aside from just

displaying
a name. So in other words i have a list of names and a text box. I want
you to be able type the name and it to auto complete as you type the name.
So say you have a list of 3 names: cooper, rich; cooper steven; smith,

joel;
in the text box i have typed "smi" and it auto completes to smith, joel.
Can this be done and if so how?






All times are GMT +1. The time now is 12:11 AM.

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