Maybe you can take some ideas from John Walkenbach:
http://j-walk.com/ss/excel/tips/tip47.htm

Bart wrote:

Hi there,

I would like to know how to check the content of a combobox to avoid doubles
in the list.
Can anyone help me with this?
Thanks in advance!

Greets,
Bart

--

Dave Peterson