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.

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

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