Autocomplete Data Validation Combo Box

  • Thread starter Thread starter Asha
  • Start date Start date
A

Asha

Greetings,

I refer to the code in http://www.contextures.com/xlDataVal11.html for
auto-completion of data validation using a combo box.

Would it be possible to modify the code to achieve the following:
1. Call up the combo box on single click instead of a double click
2. If I enter a value in the cell which is not available in the list, it is
accepted. Also, an incorrect value can be pasted into the cell. Can incorrect
input (either by direct input or copy / paste) be prevented.

Thanks
 
Back
Top