is there any way to do ti so you do not have to double click in the cell?
--
Kevin


"Gord Dibben" wrote:

DV dropdowns to not allow autocomplete.

See Debra Dalgleish's site for instructions on how to combine DV with a Combobox
which allows autocomplete.

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Thu, 22 Nov 2007 05:42:03 -0800, Kevin
wrote:

Hi

Using Data / validation I have created a list box with predefined values eg
"Kevin", "Paul", "John", "Keith".

I would like to enable an autofil feature such that if you enter the first
letter of a value in the list you can see available values. I see 2 ways it
can happen using above 4 values as example

1. If I enter "K" a drop down list appears showing "Kevin" and "Keith" and I
can arrow up down to choose. I see this a lot when selecting airports in
airline reservation websites
2. When entering letters once you get a unique possibility compared to the
list the value pops up and you can just enter eg if i type "KE", nothing but
if i enter "Kev" then Kevin is highlighted - this already happens in excel
but only if the value is already displayed in cells above ie not connected to
the values in the list

any advice welcome. I can code a little but not an expert so easiest
solution probable best, which i think is 2 but I would prefer to be able to
do no 1