Auto complete for a combo box

[Billyberu]

I have a long list on sheet 1 called Activity.
I have a combo box on Sheet 2 to reference the Names in the list Activity.
I want to be able to type in the combox the first letter of the name and it narrows down the choices. Then when I type in the second letter of the name it narrows the choices even more. The more of the name I tye the less choices I have.

I will have several comboboxes using this list (if possible) and some may be left blank.

If someone could make a working example I would really appreciate it. I am just learning to use excel.

Thanks

 

[Jaafar Tribak]

Have you tried setting the MatchEntry Property of the ComboBox to fmMatchEntryComplete ?


Regards

 

[Billyberu]

I have Excel 2003. Where would I find MatchEntry and how would I use it?

 

[Billyberu]

Jaafar

Found matchentry and it works. Thanks for the information.

 

[Jaafar Tribak]

Activate the ComboBox (in design mode),right click the mouse and pick "Properties" from the menu . Scroll down the Properties window till you find the "MatchEntry" item on the list and click on it. A dropdown will appear to the left from where you can chose the "fmMatchEntryComplete" constante .Exit the Design mode.

I hope this helps.

Regards.