ListBox question

[Cesar Zapata]

HI,

I have a listbox in a userform.... the listbox contains a list of reports...
then the user selects one and press OK to download the selected report from
a server.

I would like to have the user the chance to select and be able to open more
than one report at one time?


the reports name list is in column A.


thanks,

 

[Tom Ogilvy]

set the multiselect property to true.

With listbox1
for i = 0 to .Listcount -1
if .selected(i) then
sStr = sStr & .List(i,0) & vbNewLine
end if
Next
End With
msgbox sStr