drop down box

[TCarson17]

I have a drop down box in a seris of cells that I use an input field to key a lookup table to bring desired information from a database to the fields I want on another worksheet. The key is first and last name. Everything works great I was wondering if there is a way to modify this drop down box so that when I start typing the box pops up and scrolls the names to match what Im typing and the closer I get to finishing the name it continues to scroll until it gets to the name im typing. Just curious, becasue if i misspell a name then i have to click the drop down box and scroll through the list to find the correct name. Thanks for any help

 

[TCarson17]

bump

 

[parry]

Hi the functionality is defined by the MatchEntry property. You can either have no matching, only match the first letter or match as you type (the default). It has pre-defined settings so I dont think you can alter its behaviour other than choosing one of these three options. You will just have to become a better typist.

If the list is sorted you can type 3 or 4 letters and use the drop down and you should be pretty close. If you have mistyped you can delete a few characters and this may put you back on track for finding the one you want.

hth