Hi all,

I currently have this code to fill a dropdown with the names of all the sheets in my workbook:

Sub Fill_Drop_Down_With_Names()
    With Sheets("Sheet1").DropDowns(1)
        .RemoveAllItems
    For I = 1 To ActiveWorkbook.Sheets.Count
            .AddItem ActiveWorkbook.Sheets(I).Name
    Next I
    End With
    Sheets("Sheet1").Select
End Sub
I would like to add a default value to that dropdown that says something like "Please select a name..." and the only way round it I can currently see is to have a textbox laid on top of the dropdown with the text "Names" in it.

I've seen on a recent thread how to achieve this if the control is a ComboBox on a Userform but this is dropdown on a sheet.

Any help would be much appreciated

Seamus