I have a form which when loaded populates the value/text of cells , say A1
to A10 into a combo box using the additem method.
Within this range off cells are duplicate entries and blank cells. I only
want to add to the combo box one occurrence, and ignore blank & duplicate
cells.
For example if below, were cells A1 to A10, i only want to see John, Dave
&
Steve added once to the combo box.

http://www.j-walk.com/ss/excel/tips/tip47.htm

This is for a ListBox, but it will work for a ComboBox
with minor and obvious changes.

HTH,
Merjet