VBA Dropdown propblems

[sgrzzl]

I am using several dropdowns on my user form to display list items from a dynamic range using the following:

Private Sub UserForm_Initialize()
ComboBox1.Rowsource = "dynamicrange"

End Sub

The list works but it will not let me select the first item on the list. This is problems something simple but I don't much about VBA.

 

[jbeaucaire]

Without being able to see your workbook or extended coding, first though is to replace the "unselectable" first item in the range with a note like: "Select one..."
Move the other items down.

 

[sgrzzl]

I've already tried that and it didn't work.

 

[jbeaucaire]

The list works but it will not let me select the first item on the list.

I don't see how changing the value that appears as the first list item (the one you can't pick but the rest of the list work), I don't see how changing that text doesn't work. It's already not selectable, anything you put in that list item is still unselectable.

My idea isn't to make the first item selectable, it's to put text in that first slot that is clearly not meant to be selected.