Validating a Cell with a Dropdown Box

[sjanaswamy]

Hi There:

I validated a cell to return a value from a list that I have create
with names of all the employees in my company. Presently the user ha
to scroll down and click the name say "Mike Jones". Is there a wa
wherein the user types the first few letters and the name i
highlighted. For example by typing M, the Cursor should go to the name
starting with M etc..

Could someone please help...

Thanks,
Srin

 

[Frank Kabel]

Hi
not possible with the data validation drown downs

 

[Debra Dalgleish]

Data validation doesn't support autocomplete. However, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

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

Under 'Data Validation', look for 'Data Validation Combobox'