I was affraid of that. The list we are using for the data validation is 9858
items long! But thank you for verifying it for me.
--
JS


"Gord Dibben" wrote:

Not by using a dropdown list from Data Validation.

Combobox is generally the workaround.


Gord Dibben MS Excel MVP

On Mon, 24 Nov 2008 11:31:41 -0800, Judy
wrote:

Is there a way to program a drop down list in excel to auto fill while
typing? I know it can be done by a combo box, but we would prefer to keep it
as a drop down list and access is not an option at this time. Thank you