I got this from a book and it is almost what I need but I need to twea
it and can't seem to make it work.

The For i& makes me pick a range from 3 to 300 or a different number
Is there a way to make it pickup only unique names in that column, s
that the combo box only populates with those names and not a bunch o
blank spaces???

Private Sub UserForm_Initialize()
Dim i&
With ThisWorkbook.Sheets("Active Collection")
For i& = 3 To 300
cmbClient.AddItem .Cells(i&, 4).Value
Next i&
End With
cmbClient.ListIndex = 0
End Sub

I would like to still start with row 3

--
Message posted from http://www.ExcelForum.com