If you are looking for autocomplete in a dropdown list then ComboBox is only
way.

DV dropdowns do not support autocomplete.

But autocomplete will work without any type of dropdown if the values lie in
a contiguous range above or below the entry point.


Gord Dibben MS Excel MVP


On Fri, 27 Feb 2009 07:57:03 -0800, Alex Garner
wrote:

Can auto-complete only be used in conjuntion with a combo-box? Or is there
another way?