How to stop ActiveX Combo Button drop down auto filling.

[90yeomana]

Hello.

In my example I have created a searchable drop down for data in a list. When I start to search it narrows down the entries. But at present it is auto completing meaning its narrowing down to quickly. I would like to turn the auto complete off.

For example when you type '1' its auto completing to '1.2m Cycle Logo' but there are other options with 1 which should appear also.

Thank you in advance.

[torachan]

Get rid of your entry in 'Name Manager'
Then in combobox properties window > list range > just enter A2:A199