list box

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.
 
T

Tom Ogilvy

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
 
Top