L Lee Feb 3, 2004 #1 How can I record the mulitple selection made by a users through a list box? (link cell is only for single selection). thanks.
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 Feb 3, 2004 #2 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
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
