Private Sub UserForm_Initialize()
Dim col As New Collection
Dim iRow As Integer
iRow = 1
On Error Resume Next
Do Until IsEmpty(Cells(iRow, 1))
col.Add Cells(iRow, 1), Cells(iRow, 1)
iRow = iRow + 1
Loop
For iRow = 1 To col.Count
cboNamen.AddItem col(iRow)
Next iRow
On Error GoTo 0
cboNamen.ListIndex = 0
End Sub