using pulldown list with a list and autocompleet function


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
 
Ad

Advertisements

P

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
 
Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top