list box
 

How can I record the mulitple selection made by a users
through a list box? (link cell is only for single
selection). thanks.

list box
 

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

--
Regards,
Tom Ogilvy

"Lee" wrote in message
...
How can I record the mulitple selection made by a users
through a list box? (link cell is only for single
selection). thanks.