Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List More
I have a drop down list, I want it to select the choice when the first letter
is typed in. How can I do that? I just need the dropdown to ensure there are no typos in the answer. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List More
One way is to sort your validation list and at the beginning of the A's enter
a single A, do the same for the beginning of the B's and all the way through to the Z's. Click in the cell that has the drop down validation and type in the letter of the list you desire... say you type in an O. DO NOT hit enter... leave the cell in the edit mode (still selected) and now hit your down arrow. Should take you to the O which is the top of the O list of selections Cheers "bettyh" wrote: I have a drop down list, I want it to select the choice when the first letter is typed in. How can I do that? I just need the dropdown to ensure there are no typos in the answer. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List More
DV dropdowns do not have autocomplete capability.
See Debra Dalgleish's site for combining DV with a ComboBox. http://www.contextures.on.ca/xlDataVal10.html Gord Dibben MS Excel MVP On Tue, 24 Nov 2009 13:34:02 -0800, bettyh wrote: I have a drop down list, I want it to select the choice when the first letter is typed in. How can I do that? I just need the dropdown to ensure there are no typos in the answer. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |