Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming |