Sorry about that...

I want to have a small userform with a dropdown that has a list of th
clients I work with. I use...

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

to get the list.

I would like it to call another userform that has five textboxe
populated with the remaining information that is in the rows calle
above...does this help

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