Remove duplicates and sort data for populating a combobox using VBA

Hi all

I am trying to populate a combobox on a userform with data list from a sheet (strSheetName). I want to first remove duplicates and blanks from the list, sort the data in decending order and then populate a combobox.

I have the code to remove duplicates and populate the combobox as shown below, but I don't know how to amend it to remove blanks and to sort it. Can anyone help advise?

Please Login or Register  to view this content.

Any suggestions?

Other method

Please Login or Register  to view this content.

Jindon

You have come to my rescue again! Works much better now, but it's giving list from z to a. How can I make it a to z?

Thanks very much

A-Z...
Remove

Please Login or Register  to view this content.

Sorted! (pardon the pun!)

Thanks, friend