Autocomplete Data Validation Combo Box

A

Asha

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

I would like to call up the combobox in a single click, instead of a double
click as per the current code.

Also, I am able to enter an invalid value (ie, value not from the data
validation) list in the combo box.

Is it possible to modify the code to

1. Call up the combobox in a single click
2. Prevent an invalid input, whether by direct entry or copy/paste (value or
all) into the cell having the validation

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocomplete Data Validation Combo Box 0
Combo box 0
Data Validation AutoComplete Help 5
get Data Validation to stop, list supplied, duplicate data entries 1
Data Validation - Combo Box open with single click 0
Creating a Search using a combo box and then creating a report. 4
Adding a VLookup to an AutoComplete ComboBox 0
execute assigned data validation in vba? 11

Top