Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using pulldown list with a list and autocompleet function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using pulldown list with a list and autocompleet function
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using pulldown list with a list and autocompleet function
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using pulldown list with a list and autocompleet function
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using pulldown list with a list and autocompleet function
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External excel file for pulldown list source | Excel Worksheet Functions | |||
How to set excel pulldown list starting value to current cell valu | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Worksheet Functions | |||
Still need help with hyperlinks in pulldown list. Anyone know how | Excel Discussion (Misc queries) |