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.

One way:

Put something like this in the ThisWorkbook code module:

Private Sub Workbook_Open()
Sheets(1).DropDowns(1).Value = 0
End Sub




In article , "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.

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