Private Sub UserForm_Initialize()
Dim iRowL As Integer
iRowL = Cells(Rows.Count, 1).End(xlUp).Row
lstMulti.List = Range( _
Cells(2, 1), Cells(iRowL, 3)).Value
End Sub
Private Sub lstMulti_Click()
Range("D1") = lstMulti.Value
End Sub