View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Goodall David Goodall is offline
external usenet poster
 
Posts: 21
Default populate combobox with sheet names

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