Combo Box Help

[David]

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.

John
John

Dave
Steve
John

Dave
John
Steve

Thanks again

Dave

 

[merjet]

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