Sort ListBox alphabetically

Hi All,

I have the following code which grabs the list I need from a column, but I'd like it to sort it alphatebetically as it is a long list and would be eaiser to locate a name from it.

Please help!

Please Login or Register  to view this content.

Originally Posted by 6StringJazzer

It would be easier to sort the data in sheet "MCS RAW DATA" before loading the list box. Is that a feasible option?

There's a lot of data so ideally want to avoid touching it!
But if it does a clean sort, then don't mind.

The sheet has about 15 columns, and hundreds of rows!

Also, if you can help with only adding name once (remove duplicates), that would be great!

Thanks

Looks like daboho has a good solution. Anything that has a sort built in is better than writing one from scratch. I don't know about the duplicates part, though. The Dictionary class seems to handle that well.

Originally Posted by alimsab

The sheet has about 15 columns, and hundreds of rows!

Also, if you can help with only adding name once (remove duplicates), that would be great!

Try this

Please Login or Register  to view this content.

Tried second one, and looks like it's done it! Thanks