Combo box command to select from unique data list

**AndyE** · 11-17-2010, 05:53 PM

I am looking to use a combo box in a useform to populate cells contained in a single column on a worksheet, using data already entered into that column. The column contains multiple entries, some of which are, and will be duplicates.

What I am trying to achieve is have the combo box list the available previously typed entries, although in the format of a unique list, sorted alphabetically (if at all possible), whilst being dynamic in that I can enter 'new' entries as well as choosing from the previous ones.

Can anyone help with a solution?

**davesexcel** · 11-17-2010, 09:59 PM

This should populate the combobox with no duplications, the list being in ColumnA

Please Login or Register  to view this content.

Check out the attached example.
I got the code to add to the list many years ago and wish I could find it to reference it.

Anyway, you can type in the ComboBox a new item and it will add the item to the list