Filter and Sort Scripting Dictionary

I'm having an issue filtering and sorting a scripting dictionary. The macro I am using creates a dictionary and displays it on a userform. However, there repeated values in the dictionary, and the values are not in alphabetical order. Is it possible to do put the values in alphabetical order and remove the duplicates? Any help is appreciated.

Please Login or Register  to view this content.

Dom,

Thanks for the quick reply. Looks like this will work, but I have one further question. Where would I integrate this function? To be honest, I'm pretty green when it comes to VBA. I added the code from your link, and integrated the relevant parts to my macro, but I get the error "type mismatch". Here's what I have thus far.

Please Login or Register  to view this content.

hi Jbryce22, as a suggestion: if you are allowed to change the order of the range ("D4103" ...) rows you can sort it before proceeding with dupes elimination

Hi,

Please upload your sample workbook to do vba activity.

Here's my workbook. Any help is greatly appreciated.

Watersev,

That is one way to do it, but I would prefer to have that done in the scripting dictionary if possible. I'd rather not have to sort the data source unless there is no other way to accomplish this.

Please Login or Register  to view this content.

Kenneth, thanks for this. I'm having trouble integrating this. Is this supposed to be in lieu of my current macro, or in addition to? I'm not very well versed in VBA, and I apologize if this is annoying. I just really want to get this to work. Thanks!

Please Login or Register  to view this content.

It should probably go something like:

Please Login or Register  to view this content.

Kenneth, again, thanks for your help. I wasn't able to get this to work. It's still not sorting or filtering. Do you have any other suggestions?

I am not sure what you mean by filter.

Your original code eliminates dups. My sort routine sorts it. You need to move your data out of sort order to see that. Of course your routine is only doing it for the first combobox. I am not why you resized the range to 3 if you only wanted the Column A data for combobox1.

My apologies. I think I misscommunicated. The reason I have my range set to 3 is because I would like for combobox2 to include the 3rd column in my data range (Manager). I should have clarified better my needs. I was hoping to have combobox2 sorted and the dupes removed from it. Using your quicksort, I am able to sort the combobox2, but I am unsure of how to remove the duplicates from it. Again, any help is appreciated. Many thanks, Kenneth.

You have some other issues after selecting the first one but this fills and sorts both comboboxes.

Please Login or Register  to view this content.