fmMultiSelectMulti option in listbox not available on Mac?

[jonck]

Hi all,
I'm trying to program a little macro in Excel where (after some other
things have taken place) the user should be able to select the topics
that he wants from a listbox. However, I'm experiencing problems with
the MultiSelect option of the listbox. When I try to populate the
listbox with the fmMultiSelectSingle option, everything works fine
(except of course for the fact that the user can now only select 1
option at a time). When I then choose the fmMultiSelectMulti option for
the listbox, and I run the app, when the point is reached where the
listbox is going to be populated (tried both setting the List() as well
as using the addItem method) Excel crashes.
Has anyone experienced anything similar? Does anyone know a workaround?

Thanks for any help, Jonck

 

[Kristina Conceicao]

Hi all,
I'm trying to program a little macro in Excel where (after some other
things have taken place) the user should be able to select the topics
that he wants from a listbox. However, I'm experiencing problems with
the MultiSelect option of the listbox. When I try to populate the
listbox with the fmMultiSelectSingle option, everything works fine
(except of course for the fact that the user can now only select 1
option at a time). When I then choose the fmMultiSelectMulti option for
the listbox, and I run the app, when the point is reached where the
listbox is going to be populated (tried both setting the List() as well
as using the addItem method) Excel crashes.
Has anyone experienced anything similar? Does anyone know a workaround?

Thanks for any help, Jonck

Are you using Excel 2004? I ran into the same problem last summer. At
the time, I happened to be communicating with a tech at MS about a
different issue, and asked them to look into it. They were able to
repro it and agreed that it appeared to be a bug.

As for a workaround...I ended up using fmMultiSelectSingle. On my form,
I have a second list box that starts out empty. The user selects an
item from the first list, then clicks an "Add" button to add it to the
second list. This allows them to add multiple items to the second list
(one by one). I then use the contents of the second list to proceed
with the rest of the code. Not as elegant of a true multiselect, but it
works well for my purposes.

Kristina

 

[jonck]

Are you using Excel 2004? I ran into the same problem last summer. At

the time, I happened to be communicating with a tech at MS about a
different issue, and asked them to look into it. They were able to
repro it and agreed that it appeared to be a bug.

I am indeed using Excel 2004.

As for a workaround...I ended up using fmMultiSelectSingle. On my form,
I have a second list box that starts out empty. The user selects an
item from the first list, then clicks an "Add" button to add it to the
second list. This allows them to add multiple items to the second list
(one by one). I then use the contents of the second list to proceed
with the rest of the code. Not as elegant of a true multiselect, but it
works well for my purposes.

After not being able to get the multiSelect working I ended up doing
just what you describe. Indeed not quite as elegant, but oh well, it'll
have to do.

Thanks for your reply, Jonck