Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - enter first letter and find?
Is there a way in Excel where you can start typing the name and it will try
and fill it out from a list? I know in Access, you can create a form that when you enter the first letter in a field it will try and find from a table the item you want. I also know in my excel 2007 you can setup a Data Validation to link to a named list so all you need to do is choose from a drop-down your item. The issue is that the list I have for the names to choose from is almost 3,000 lines and people want to either start typing and see a list of choices or have the dropdown and type a letter to get to the start of that name? Any suggestions would be helpfull thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - enter first letter and find?
Don
If using a Data Validation List Dropdown, there is no Autocomplete function. Debra Dalgleish shows how to use a Combobox in conjunction with the DV in order to enable autocomplete. http://www.contextures.on.ca/xlDataVal10.html An alternative using a couple more cells comes from Ashish Mather Please take a look at question 44 of the following link - http://ashishmathur.com/replies.aspx Another method...................... When setting up the List make sure your List is sorted alphabetically then add a single letter at top of each group of items like A, B, C etc. Then type a letter, say H, in the dropdown..........don't hit ENTER but click on the arrow. You will be taken to top of "H" items. Thanks to Howard Kittle for this. Gord Dibben MS Excel MVP On Wed, 20 May 2009 10:50:56 -0700, Don wrote: Is there a way in Excel where you can start typing the name and it will try and fill it out from a list? I know in Access, you can create a form that when you enter the first letter in a field it will try and find from a table the item you want. I also know in my excel 2007 you can setup a Data Validation to link to a named list so all you need to do is choose from a drop-down your item. The issue is that the list I have for the names to choose from is almost 3,000 lines and people want to either start typing and see a list of choices or have the dropdown and type a letter to get to the start of that name? Any suggestions would be helpfull thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I enter a valid number in a cell with data validation | Excel Worksheet Functions | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
How do i set up data validation to only enter yes or no? | Excel Worksheet Functions | |||
Data Validation - Do not allow the letter "O" | Excel Discussion (Misc queries) | |||
Find column letter containing specific data | Excel Worksheet Functions |