using pulldown list with a list and autocompleet function

  • Thread starter Thread starter Peter Jonkers
  • Start date Start date
P

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
 
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
 
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
 
Back
Top