It doesn't work (run-time error nr. 91). However this put in right cell
the 4th item. I don't want this, I want my combo's menu open without
using F4 or clicking for open list of item.

Thanks Tom!


Tom Ogilvy ha scritto:

Private Sub Userform_Initialize()
Combobox1.ListIndex = 3
End Sub

Selects the 4th item in the combobox.