Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto-complete an entry in drop-down list
In Excel 2003, I need to be able to auto-complete an entry in a drop-down
list. I have set up a drop-down list that includes over 1000 entries. I would like to be able to type the first letter or two and get a list of available options from the list that includes those first few letters. |
#2
|
|||
|
|||
If you created the dropdown list through Data Validation, it doesn't
support autocomplete. If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html Jason wrote: In Excel 2003, I need to be able to auto-complete an entry in a drop-down list. I have set up a drop-down list that includes over 1000 entries. I would like to be able to type the first letter or two and get a list of available options from the list that includes those first few letters. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thank you for your response. I was afraid my answer would include some
programming. "Debra Dalgleish" wrote: If you created the dropdown list through Data Validation, it doesn't support autocomplete. If you can use programming, there are instructions here for adding a combobox from which you can select one of the values from the data validation list. In the combobox, you can enable autocomplete: http://www.contextures.com/xlDataVal11.html Jason wrote: In Excel 2003, I need to be able to auto-complete an entry in a drop-down list. I have set up a drop-down list that includes over 1000 entries. I would like to be able to type the first letter or two and get a list of available options from the list that includes those first few letters. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding value to drop down list | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
Drop down List problems | Excel Discussion (Misc queries) | |||
Drop Down List for Chart | Excel Discussion (Misc queries) | |||
double-clicking a list entry | Excel Discussion (Misc queries) |