make a combo box more userfriendly

[nhbcai]

Hi Guys,

I have a userform where the user must select a company name and click a comand button.

The problem is I will probably end up with about 3000 different company names...so a combobox will be anoying to use.

Are there any other options??? Maybe if the user typed the first letter of the company (or first few letters) into a textbox, then clicked on the combobox, only companies which started with whats in the text box would be displayed...is that possible? So if the user typed 'S' into the textbox then the combobox would only show company names starting with S.


Any help on this would be really appreciated.

 

[Peter_SSs]

I have moved both your recent threads from the 'General Excel Discussion & Other Questions' forum to the 'Excel Questions' forum.


Note the following extra information given at the top of the 'General Excel Discussion & Other Questions' forum:

*Do not post questions about Excel or Access in this forum* This forum is for Excel-related discussion and questions concerning programs other than Excel or Access.

 

[Ruddles]

I think you need to use an ActiveX combobox rather than a Form combobox and set the MatchRequired property to True.