I'm not sure if I have the right terminolgy for this but what I am asking is there a way to complete a cell or offer suggestions from a list words as the user starts to type
for example as the user types LO it brings up LONDON from the city list ?
I'm not sure if I have the right terminolgy for this but what I am asking is there a way to complete a cell or offer suggestions from a list words as the user starts to type
for example as the user types LO it brings up LONDON from the city list ?
in general... not the way i think you are wanting it to work...i assume you want it like google search AutoComplete/Autosuggest
you can do autocorrect...add LO replaces with LONDON....however this isnt the drop down from list
and it is very time consuming to create and maintain
With data validation it is plausible
you type in first (few) letter the DV changes to only with these letters
however.....there is quite a lot of background work to set it up
http://www.excelforum.com/excel-gene...alidation.html
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This thread might help you out.
http://www.excelforum.com/showthread.php?t=1079753
There's an add-in at https://app.box.com/shared/ono8ni9xvr, a read-me at https://app.box.com/shared/4qxybepxxr, and an example workbook at https://app.box.com/shared/e8dbbple34 to do this.
Entia non sunt multiplicanda sine necessitate
Neil Firth has a You Tube video for a searchable dropdown list usng formulas. Here is the link. I have used it many times and like it a lot.
Jim OHTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks