Are the dropdowns created using Data Validation?
DV dropdowns have no autocomplete feature.
You must use a combobox in conjunction with the DV list
See Debra Dalgleish's site for instructions on programming
http://www.contextures.on.ca/xlDataVal10.html
Gord Dibben MS Excel MVP
On Mon, 12 Nov 2007 11:10:01 -0800, Jeniam
wrote:
Set up a drop-down, but want to be able to type a letter to send it to the
first letter in the drop-down list. For example, if you had a list of
states, and you hit the "W" key, it takes it to "Washington"