Type Ahead Combo Box in MSExcel

[David Wilkinson]

I am using a drop down combo box in many of my forms. Its called:- ComboBox_ContractorSearch
It is populated from just one spreadsheet page in my excel workbook.
Workbooks(“MainPage.xls”)
Worksheets(“T_Contractors”)

I want to make this combo box auto-complete in the following way:-

1. When I begin to type a contractor’s name in the textbox the box drops down with a complete list of all the contractors whose names start with that letter.
2. If the name I want appears in the list I want to be able to click on it so that the name appears in the text box area while the dropdown list disappears.
3. Else I type another letter and the dropdown list automatically shortens up to include only the names of contractors who have names starting with these two letters.
4. This would be a much shorter list and would probably have the name I want, but if not, I want to continue typing with the drop down list continually shortening up until it has the name I want, or is not visible any more.
Can anyone show me how to do this using VBA in Office 2000 XL

[BrianB]

Perhaps setting the AutoWordSelect property to False will do what you want ?