Alphabetically sorting a ListBox

[jomili]

I made a little column navigator, and used the below macro to sort the column list alphabetically. It works well except for when it doesn't. I've attached my workbook so you can see it in operation. The issue I first noticed is FUNCTION comes before Full, CPS UNIT comes before City, Cost Pool Up comes before Cost of Living; I'm thinking it may be a CASE thing, but if so I don't know how to correct it. Any help would be appreciated.

Please Login or Register  to view this content.

[jomili]

I figured it out. Just had to put this at the top of the module.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Yes, I think it was "a CASE thing" all right!

See if the following version of your code does what you need:

Please Login or Register  to view this content.

Nice application by the way!


Hope this helps.

Regards,

Greg M



P. S.

By the way, The chapter on "Optimizing VBA Performance" in "Professional Excel Development" (Bovey, Wallentin, Bullen & Green) says that the use of Option Compare Text isn't really recommended.

Just pointing it out for what it's worth

[Greg M]

Hi again,

Many thanks for the Reputation increase - much appreciated!

Best regards,

Greg M