list box

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

How can I record the mulitple selection made by a users
through a list box? (link cell is only for single
selection). thanks.
 
Dim i as Long, sStr as String
sStr = ""
for i = 0 to listbox1.listcount - 1
if listbox1.selected(i) = True then
sStr = sStr & listbox1.list(i) & vbNewline
end if
Next
msgbox sStr
 
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

Saving values from Multi-select List Box 2
combo box 2
Prgrammatically added OLE Listbox, now cannot select from it 9
list box 1
Worksheet_Change and range test 1
Copying List box values/selection to a database of sorts 2
Problem disabling double click event 1
List box sort 2

Back
Top