Combo Box Search

[rfletcher35]

I have a combo box that has a lots of info, I want to be able to search in this by just typing information. So if I was to search for Richard Fletcher in the list I could start typing "Rich" or "Fletch" or even a unique id number that was also in the associated with the name.

How is this done please to save me from having to just scroll down the list until I reach my required information.

Thanks

Fletch

 

[My Aswer Is This]

On the top row of the combobox you will notice it's empty. In that row enter Ja and the list will jump to Jack for example.

 

[rfletcher35]

I agree that's what I would have though but it's not doing anything when I type in there.

 

[My Aswer Is This]

It works for me. What type Combobox is this?

A UserForm Combobox
A Form Combobox
A Activex Combobox

???

 

[rfletcher35]

Setup a new one and now this works sort of. It will only let me type in the unique number to search on where as I am wanting to be able to type in anything within the fields of data specified, any ideas?

 

[My Aswer Is This]

Give me a example of what you have in the Combobox and what you want to type in.

When I have:
Carol Johnson
Carol Michaels
Carol Adams

I type in Ca is jumps to Ca and if I continue if keeps going

The whole purpose of this box is so you do not have to type it all in.