Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete Data Validation Combo Box
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocomplete Data Validation Combo Box | Excel Programming | |||
data validation and autocomplete -- again... | Excel Discussion (Misc queries) | |||
Data Validation Combobox w/autocomplete | Excel Discussion (Misc queries) | |||
Autocomplete in data validation with separate workbook | Excel Programming | |||
AutoComplete / Data Validation | Excel Worksheet Functions |