If the dropdown was created from DataValidationList
DV list dropdown has no autocomplete feature.
You will have to use a ComboBox to achieve this using VBA
See Debra's Contextures site for how-to.
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
On Sun, 30 Sep 2007 12:38:01 -0700, Grams
wrote:
Is there a way in Excel when you are using data entry from a drop down list
to start typing and have the menu show the list options, instead of having to
scroll through EVERYTHING? For example, if I had a list with names on it, can
I start typing "gram" and have the menu show the first entry with "g", and
then go to the next entry with "gr", etc. etc
thanks