Sorting a listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm have a worksheet with lots of tabs in it. I'm using the code below to
populate a listbox with all the sheetnames, however I would like the results
sorted in alphabetal order. Any ideas would be much appreciated. Thanks!

Sub PopulateListbox()

ListBox1.Clear

For i = 1 To Sheets.Count

ListBox1.AddItem Sheets(i).Name

Next

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox Output to Individual Listboxes 1
Listbox displaying incorrectly on opening worksheet 3
list box remove item by combobox 4
sorting a listbox in a user form 4
Sorting a listbox when items are added 4
move item from one listbox to another listbox 6
Listbox populated with Sheet Names to Hiughlight Activesheet 2
Stopping duplications been entered into a listbox 8

Back
Top