Rob,

If you are talking about a userform try adding this to the Initialize event.
Change Combobox1 to your Combobox name.

For Each wksheet In Worksheets
ComboBox1.AddItem wksheet.Name
Next

If this is a worksheet form you will need to create a range containing a
list of all the worksheet names and set the ListFillRange property of the
Dropdown box to that range.

HTH,
Matt









"Rob Hargreaves" wrote:

Hi I have created a form and I would like to have a drop down on the form
populated with the names of each sheet in my workbook (Other than the sheet
named "Menu")

Can someone tell me how to do this.

Thanks

Rob