Only unique values in combobox.

[dotchiejack]

Hi,
I am populating a userform combobox from a userform listbox.

Please Login or Register  to view this content.

Now I want to add code to remove the doubles in the combobox.
Any Ideas?
Thanks

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[nigelog]

Dotchiejac

other way around here but using dictionary to control 3 boxes

adapt for your use if suitable

Edit simplified version. Can get it to work for another listbox but not combobox. Something simple.

Ill post if I sort - I had to combobox so big i couldnt see the entries

Please Login or Register  to view this content.