data validation for dropdown list with autocomplete

[feltonam]

I needed to provide a dropdown list of many values which also had an autocomplete function, and the script at

http://www.contextures.com/xlDataVal11.html

works brilliantly, but just one problem.

Users can overtype with any value including those not in the list. Is there any way this code can be modified so that list values only can be entered in the cell?

 

[SkipVought]

hi,

Did you include the Data > Validation steps?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[feltonam]

Yes, I have Data Validation set to show error alert after incorrect data entry for all the cells using dropdown lists. The validation message works when the Contextures code is not applied to the worksheet, but it doesn't work with the code applied.

I note that the Data Validation option is also grayed out on the Excel 2007 ribbon when any cell with a dropdown is active while the code is applied.

Data validation rules in other cells without dropdown lists work OK.