Restrict values to list data when using AutoComplete with ComboBox?

[Galley]

I use validated drop-down lists quite often with lists of up to 50 items. I am working on a project with one drop-down list linked to a named range containing nearly 500 items. Since there are so many items, I wanted to use AutoComplete.

I found this code from the fine folks at Contextures: http://www.contextures.com/xlDataVal11.html

If used as a standard drop-down list with Excel's built-in validation, only list items may be selected. If used as combobox however, the user may enter a value that isn't in the list. Is there a way to prevent this from happening?

Thanks

 

[sunnyland]

If you use a combobox [activex control] then you have the property MatchRequired that you can set to true to limit to required entries.