Here's my scenario:

I'm using data validation to create drop downs in a spreadsheet that will be
filled out by the user moving from cell to cell. The powers that be would
like for the cell to either autocomplete with the best match (as a combobox
control would do) or at the very least, jump down in the list to the first
entry beginning with the letter the user types. I'd like to do this without
putting a in control in place of the cell. Does anyone know code that would
give a cell this functionality? I'm guessing it'll just have to be a change
event that looks up the value in the cell, but I'm hoping for an alternative.