VBA Excel Alphabetized listbox

Question

In VBA for Excel, I have already written a code to give a ListBox a rowsource, but how do I make that list be in alphabetical order without a previously written function to do so?

Tiago Cardoso · Accepted Answer · 2011-02-27 01:52:43Z

-1

Have you tried lvMyList.Sorted = True?

answered Feb 27, 2011 at 1:52

Tiago Cardoso

2,1061 gold badge16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jon Over a year ago

I did not try that, but I did figure it out, Thanks!

Tiago Cardoso Over a year ago

@Jon would be interesting to have the proposed solution shared on the site, properly setting the question as answered. This way you can help other developers with the same quesion.

Collectives™ on Stack Overflow

VBA Excel Alphabetized listbox

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related