How do I get value of a multi-selection form listbox?

I've never used the form listbox before. I've always used data validation list.

How do I get the selections into my macro? I have my macro putting the listbox into an object, but I can't find a value.

Please Login or Register  to view this content.

Hello foxguy,

You have to loop through the entries and test if the Selected property is true.

Hi Leith;

Yeah, I figured it out on my own. I was coming here to mark the thread solved and saw your message.

Hi Leith;

Can you explain this?
In my macro I assign the listbox to an object. In the locals window I look at the object and the ListCount says 0 even though I have 3 items selected.
And when I type ? .ListCount in the immediate window, I get 3.

What was the code you used to assign it, and which line were you on? (Note: Listcount has nothing to do with how many items you have selected, it's the number of items in the list)

Originally Posted by romperstomper

What was the code you used to assign it, and which line were you on? (Note: Listcount has nothing to do with how many items you have selected, it's the number of items in the list)

Here is my entire sub.

Please Login or Register  to view this content.

It printed 3 in the immediate window.
When it hit the Stop, I opened the Locals window and expanded "o". It said that Listcount was 0. There were three items in the List, and 2 of them were selected (strText correctly had 2 lines in it).

Interesting - I've never noticed that before (It also has the ListIndex wrong). Even if you populate the listbox using AddItem, the Listcount still shows as 0. It would appear that it is actually only picking up the properties set at design time for some reason (presumably ListCount doesn't count since it could be assigned a dynamic range)

And that explains why I had a hard time trying to extract the value. I kept looking at the listcount=0 and assuming it had nothing to do with what I was looking for.

Live & learn.