Populating listbox with sheet names

  • Thread starter Thread starter johnb
  • Start date Start date
Is this a listbox on a userform?

If yes, you could use something like this in the _initialize routine.

Dim iCtr as long
for ictr = 2 to activeworkbook.worksheets.count
me.listbox1.additem activeworkbook.worksheets(ictr).name
next ictr
 

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 2 takes the value of Listbox 1 3
Loop through userform 2
clearing cells when selecting values from different listboxes 0
Array to Populate ListBox Problem 1
How do you get outlook to select from list on a form 1
Looping thorugh Listboxs to populate with name range 11
How to set focus on an ActiveX ListBox 7
Listbox populated with Sheet Names to Hiughlight Activesheet 2

Back
Top