Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Quick Find in long drop down list
I would like to be able to type the first few letters in a cell that uses a
long drop down list and quickly go to the full name in the list without having to start at the top of the list and scrolling down every time. -- Joe |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Quick Find in long drop down list
That one I know as one of the good guys answered for me before :
get a COMBO BOX from the control box toolbar, give the properties of the cell with the dv and move it on top of it. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Candyman" wrote: I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to start at the top of the list and scrolling down every time. -- Joe |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Quick Find in long drop down list
Sorry, I failed to say I use Excel 2007. I am unfamiliar with combo boxes and
could use more detailed instruction. Also my drop down boxes are data validation lists if that makes a difference. -- Joe "Learning Excel" wrote: That one I know as one of the good guys answered for me before : get a COMBO BOX from the control box toolbar, give the properties of the cell with the dv and move it on top of it. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Candyman" wrote: I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to start at the top of the list and scrolling down every time. -- Joe |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Quick Find in long drop down list
You can do this with programming, as explained he
http://www.contextures.com/xlDataVal11.html Candyman wrote: I would like to be able to type the first few letters in a cell that uses a long drop down list and quickly go to the full name in the list without having to start at the top of the list and scrolling down every time. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Long list, 2 criteria, find unique, paste | Excel Discussion (Misc queries) | |||
Quick Seek Data in Drop Down List | Excel Worksheet Functions | |||
Find a group of names in a long list | Excel Discussion (Misc queries) | |||
Long list of words to find with Filter | Excel Discussion (Misc queries) | |||
quick selection drop down list | Excel Worksheet Functions |