On Thursday, August 30, 2012 3:53:14 AM UTC-7, Robert Crandal wrote:
I would like to create a Userform that contains an input box

(ie textbox) and a listbox or combobox. The listbox will

contain over 500 strings of employee names. The user

should be able to easily scroll through the listbox and find

any name they are looking for.



However, to make things even easier for the user, I thought

I would let the user type in a name inside the textbox. So,

if a user begins by typing "Pet", I want the listbox to be

reduced so it only shows names such as "Peterson",

"Petrowski", "Petti-Jones", etc.... The contents of the listbox

should grow or shrink depending on what is typed in the

textbox.



What is a good way to implement this? I know how to add

items to a listbox, but I'm not sure how to effectively make

the contents of the listbox depend on the contents of the

search string in the textbox.



Thanks for your help.

Hi Robert,

Here ia a NON-vb method that "kinda does that" using Data Valadation at the worksheet level. Perhaps worth a look.

At the bottom of your list of names, add A TO Z in the next 26 rows, in caps and bold font. Now select the entire list including the newly added A to Z and sort the list using the A to Z icon.

Select the cell you want the name to be displayed in and using Data Valadation Settings Allow: List check Ignore blanks & In-cell DropDown boxes click in the Source box Select your entire list on the worksheet (leave the list high-lighted) OK.

So now, in the data valadation cell, enter any single letter, say "R" and LEAVE IT AS THE ACTIVE CELL, do NOT hit ENTER.

Now click the Drop-Down arrow, this will take you to the beginning of the R list of names. Scroll to the name you want in the R list and click on it.

HTH
Regards,
Howard