Maybe something like:

Option Explicit
Private Sub Workbook_Open()
Worksheets("sheet1").DropDowns("drop down 1").ListIndex = 0
End Sub



Marc wrote:

I have put combo box control (from Forms toolbar) on worksheet.
I have selected Input range from H11 to H15 and Drop down lines = 5.

How can I make that starting index in combo is allways 0, so that none value
is selected before I click combo? It would be nice to set this on workbook
open, but I don't know how.

Thank you.

--

Dave Peterson