View Full Version : Help needed with Filtering a Drop Down List

12-09-2008, 02:04 AM
Dear all,

I have searched this forum but cannot find any thread that can help me therefore I am posting a new thread.

I have created a Drop down List with a selection of over 1700 entries, what I would like to do is for the user to type a letter into the validated cell, open the drop down menu and the list will be displayed at the first selection that begins with the typed letter.

For example;

List has names starting from A - Z, 1700 of them, when the drop down list is opened the full list is displayed starting from A, the user then has to scroll down to the required name, now if this name begins with W, the user has to scroll through 1500 entries before they get to the entries starting with W.

What I would like to happen is that the User types in the letter W, opens the drop down list and the first entry seen is a name begining with W, this limits the amount of time taken in finding the desired name.

Hope you understand this and can help me achieve this.


12-09-2008, 03:28 AM
Hi, quite an cool name considering the current economic climate.

I hope this example workbook will shed some light.