Multi Selection of List Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Claus Mygind - 27 Apr 2005 13:11 GMT

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?

Reply to this Message

Rob Bovey - 27 Apr 2005 17:33 GMT

>I have written an app in excel version 2002 with SP-1
> installed. It contains a userform with a listbox.
[quoted text clipped - 6 lines]
>
> 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.

Signature

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

Reply to this Message