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

as far as I know you can only do that with a cobobox or listbox


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115393

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



"Simon Lloyd" wrote:


as far as I know you can only do that with a cobobox or listbox


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115393

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

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

"Max" wrote:

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