hi,

I have 10 listboxes in my userform and I can double click each listbox lines and populate information from there to 10 textboxes.

Im wondering if I can in Userform Intialize, once the userform opens that the inifromation in listboxes be populated automatically to the textboxes.

I have a code below but doesn't do anything really just selects the first list but no double click

lstLookup.Value = Selection
For i = 1 To lstLookup.ListCount - 1
lstLookup.Selected(i) = True

Next I

End Sub

Thanks

Steve