listboxes

  • Thread starter Thread starter john.9.williams
  • Start date Start date
J

john.9.williams

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prgrammatically added OLE Listbox, now cannot select from it 9
Access Cannot select items in listbox 1
ListBox Remove Certain Text 6
Populating a listbox from an excel column 2
List box value returns the row number of the list box range row 5
Userform Listbox selection change 2
Userform List Box content not visible? 6
Is this possible with a listbox? 1

Back
Top