ExcelBanter - populate combobox with sheet names

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - populate combobox with sheet names (https://www.excelbanter.com/excel-programming/309670-re-populate-combobox-sheet-names.html)

David Goodall

populate combobox with sheet names

"David Goodall" wrote in message news:...
Hello All
I'm trying to find a way to populate a combobox with the names of
Worksheets from one Workbook. I'm ok just adding sheets that already exist
but I will need to add more sheets to the workbook and the combobox needs
to update automatically. Each worksheet will have a unique name not just
Sheet1, etc.

Any help is greatly appreciated.

Regards
David

All times are GMT +1. The time now is 02:05 PM.