Auto select when using Combo box in worksheet

[Guest]

I have a combo box (ComboBox1) on a spreadsheet which is linked to a range
name ("Masterlist") which includes a list of titles. I'm trying to get the
combo box to automatically select from the list as I'm typing the characters
in the title. Does anyone have code that will allow this to happen?

I want to be able to type each letter and as I do, the selector will move up
and down the combo box matching what has been typed. Thanks for your help.

Roger

 

[Guest]

If it did that, it would interrupt your typing by filling the box with your
first match. When the selection is made, the selection is made.

 

[Guest]

Hi Tom,

I'm not sure if I was clear enough on my post. I'm trying to get the same
affect that Yahoo has on it's search engine. On Yahoo, if you were to type
in the search field, let's say "Dog ", it would automatically show a drop
down list of anything that begins with "Dog " and any trailing words in their
search list. As you type more like "Dog B" for "Breed", it would go down the
list for the closest match. Once you find what you are looking for you would
hit the enter key. This is what I'm trying to do with this Masterlist using
a combo box. I want to be able to have the cursor go down to the closest
match on my "Masterlist" range name and allow me to scroll up or down until I
find what I'm looking for and than simply hit the enter key to select. I
guess you can say it is like an autofill based on the "Masterlist" data. Is
this possible?

Thanks for your help.

Roger