What I am ultimately trying to do is add a combo box that
when you click on the drop down the drop down selections
will be tied to the values in a column. However, I only
want the unique values to be displayed?

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