Listboxes - populate with all worksheet names
 

Hello,

I would like to populate a forms listbox with all the sheetnames in my
workbook. I would also like to exclude certain sheet names from the
list.

As I add sheets, I would like this to be picked up by the code and
added to the listbox.

Is this possible?


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=560572

Listboxes - populate with all worksheet names
 

I have worked this out now. I used:


Code
-------------------
Dim wbs As Worksheet

For Each wbs In Worksheets
If wbs.Name < "ignore_sheet" Then
ListBox1.AddItem wbs.Name
End If
Nex
-------------------

--
bluegn
-----------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...fo&userid=3610
View this thread: http://www.excelforum.com/showthread.php?threadid=56057