listboxes

how can i set the control source of a list box to return the entire row
form a list

john

You can't. You would have to write code to populate your destination with
that information.

--
Regards,
Tom Ogilvy

<[email protected]> wrote in message
news:[email protected]...
> how can i set the control source of a list box to return the entire row
> form a list
>
> john
>

any hints or examples tom

regards

john

Private Sub Listbox1_Click()
rw = 1
cells(rw,1) = Listbox1.Value
for i = 1 to listbox1.Columncount -1
cells(rw,i + 1).Value = listbox1.list(Listbox1.ListIndex, i)
Next
End Sub

Above pseudo code would represent and approaqch

--
Regards,
Tom Ogilvy



<[email protected]> wrote in message
news:[email protected]...
> any hints or examples tom
>
> regards
>
> john
>