Populating sheet names in combobox
Thank you
-----Original Message-----
for i = 5 to sheets.count
listbox1.AddItem sheets(i).Name
Next
--
Regards,
Tom Ogilvy
Todd Huttenstine
wrote in message
...
What is the code to display sheet names in a combobox?
I
need it to display every sheet after Worksheets(4).
This
means I need it to display the 5th sheet and beyond. If
there are only 4 sheets and no sheet5, then I need for
nothing to be displayed in the combobox.
Thanx
Todd Huttenstine
.
|