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,

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

--
Regards,
Tom Ogilvy

"Cesar Zapata" wrote in message
...
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,