using pulldown list with a list and autocompleet function

[Peter Jonkers]

how can i make a pulldown list with autocompleet and first letter reconiction.

I have the list working with data validation
but now the rest.

The list is on sheet 2

I am now using the data Validation with list as allow
The source formula is "=Workcode" (area name) and workcode is on sheet 2.
Sheet 1 is used to display the list.

thanks

 

[Peter Jonkers]

Thanks Simon,

The dropdown list is working fine. that is no problem.
What i want is that it will autocompleet what i type.
I have about 50 names in the list end it is a pain to search in the list the
one that you want.

So..,were i im looking for is for example i type the firts letter or the
first 2, it will jump in the list to the one i need.

I hope I explained it right

cheers

 

[Max]

What i want is that it will autocomplete what i type.

Debra Dalgleish shows a way to "build in" the AutoComplete feature into DVs,
which finds matching items in the list as you start to type ..
http://www.contextures.com/xlDataVal10.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Peter Jonkers]

Works like a charm..thanks.

One minor question left.
I use the list funtion with data on another sheet. how can I change the code
to use that data.

last question
The combobox comes up with a double clik, can i change that so that when i
want to fill in the cell by one clik that the combo box is active?

thanks

Peter