I think from your post you need to look at the limit to
list of the combo.
-----Original Message-----
I am using Excel 97, I have an array in vba for the
dropdown.

If a user types something in the combobox which isn't in
the array, is there a way to check the array and if it
isn't listed to continue and change the entry of another
cell say?

Can someone help please?


Mark
.