combobox shows blank until selection made

[hitch_hiker]

I have ( with much input and help from here ) a dual column combo box in a userform, which when it starts up, shows as an empty box, when I click on the arrow button, the anticipated list becomes visible and I can select from there. What I want, is when I open the userform I can see the first rows ( depending how long I make the combo box ) and then click the arrow button to continue the list. this way the combo box becomes self explanatory. Is this possible? or am I expecting too much

the code I'm using is:

Private Sub UserForm_Initialize()
Dim cPart As Range
Dim ws As Worksheet
Set ws = Worksheets("product list")
            '  syntax modification suggested mrexcel.com Andrew Poulsom
    Set cPart = ws.Range("U9:V" & ws.Range("U" & Rows.Count).End(xlUp).Row)
  Me.cboPart.List = cPart.Value
            ' range error suggested mrexcel.com Norie
Me.cboPart.SetFocus
   
        Rem http://www.contextures.com/xlUserForm02.html
End Sub

 

[hitch_hiker]

the rem comment is supposed to say range error fix suggested ( sorry Norie )

 

[Kyle123]

Maybe something like:

Private Sub UserForm_Initialize()

With Sheets("product list")
    Me.cboPart.List = .Range("U9:V" & .Range("U" & .Rows.Count).End(xlUp).Row).Value
End With

Me.cboPart.DropDown

End Sub

 

[hitch_hiker]

Thanks Kyle,

almost worked , Your solution gives a dropdown list correctly populated in one section of the screen and the userform with the combo box in another. when I select from your list the selection goes into the combo box and everything works from there . if only I could combine your correectly populated list into my combo box. definately something to play with now

 

[Kyle123]

Ok, try this

Private Sub UserForm_Activate()
Me.cbopart.DropDown
End Sub

Private Sub UserForm_Initialize()

With Sheets("product list")
    Me.cbopart.List = .Range("U9:V" & .Range("U" & .Rows.Count).End(xlUp).Row).Value
End With

End Sub

 

[hitch_hiker]

many thanks Kyle,
that's almost done the trick, certainly workable , the input box of the combo box is still white but the list is directly below it, and works nicely
I tried to paste a pic, but I can't for some reason

 

[Kyle123]

What are you wanting in the input-box? IT would already be filled in then?

 

[hitch_hiker]

good call, I had a picture in my mind and it didn't match, but i take your point, and as I said a lot better than where I was, and looks better than the first attempt, so with many thanks , I will change the size of the combo box and it will better match my original plan