Multi Selection of List Box

I have written an app in excel version 2002 with SP-1
installed. It contains a userform with a listbox.
The "MultiSelect" property is set to
1-fmMultiSelectMulti. This works fine with this version
and higher. But when I run the app on version 2000, the
selected items do not return a value of "True". However
if I reset the property to 0-fmMultiSelectSingle it works
fine.

How can I overcome this problem?

"Claus Mygind" <cmygind@tsccorp.com> wrote in message
news:043201c54b22$3bc5d7c0$a401280a@phx.gbl...
>I have written an app in excel version 2002 with SP-1
> installed. It contains a userform with a listbox.
> The "MultiSelect" property is set to
> 1-fmMultiSelectMulti. This works fine with this version
> and higher. But when I run the app on version 2000, the
> selected items do not return a value of "True". However
> if I reset the property to 0-fmMultiSelectSingle it works
> fine.
>
> How can I overcome this problem?

Hi Claus,

I was unable to duplicate this problem on my network, and UserForms did
not change at all between Excel 2000 and Excel 2002, so my guess is that
there's a problem with some aspect of the VBA installation on the Excel 2000
computer you're testing with.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm