Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to make several worksheets populate names to another | Excel Worksheet Functions | |||
Listboxes on a worksheet | Excel Programming | |||
Populate Rows from worksheet Names. | Excel Discussion (Misc queries) | |||
List box: Populate with Range Names | Excel Programming | |||
populate combobox with sheet names | Excel Programming |