Create a dropdown list as you type in a cell

[Sinu]

Everyone has seen Excel's dropdown list as you type =formula.

Challenge. You have a column A(Company Name). As you start typing, a list should give u suggestions based on substring. The list of suggestions will be based on a list of company names(5000 Company Names) present in a different sheet.

Note: Performance is must. Lag must be very minimal

 

[Deepak]

is this required for single cell or multiple cell?

 

[Sinu]

it must work for A2:A200.

 

[Deepak]

Simply can't possible for multiple cells meanwhile you may try this..

http://www.bettersolutions.com/excel/EGH188/LE431611612.htm

http://www.ozgrid.com/Excel/autocomplete-validation.htm

 

[Sinu]

It is possible. Autocompletion wont work here because the Company Name list is huge(5000+).

 

[Deepak]

It is possible. Autocompletion wont work here because the Company Name list is huge(5000+).

That's why i said Simply can't possible

 

[Sinu]

work arounds are acceptable

 

[Luke M]

Here's my rough attempt. Needs a bit of polish, but might be close.

 

[NARAYANK991]

Hi Luke ,

Instead of using the Combobox_Change event procedure , use the Combobox_Keypress event procedure.

Narayan

 

[Sinu]

@Luke M . Close enough. Take a look at my file.

 

[bobhc]

Question moved to correct section of the forum.

 

[Luke M]

Looks nice, glad you got it working.