Check if any ListBox items are selected?

[VAer]

ListBox property: Allow multiple selection

Is there a single line of code to check if a ListBox has any selected items? I think I know how to loop through the ListBox and check if each item is selected or not. But not sure if there is a quick way to check if ListBox has any selected items.

Thanks.

[kev_]

Please Login or Register  to view this content.

Test in attached workbook

[VAer]

Please Login or Register  to view this content.

Test in attached workbook

Thanks, that is also what I thought, but my question is: if there is a quick way to determine the result, rather than looping through each item.

Anyway, I can loop through it.

[mjr veverka]

And another clone ... ... for one UserForm (UserForm1), one ListBox (ListBox1), two command buttons (1 and 2):

Please Login or Register  to view this content.

[kev_]

Specificaly testing for nothing selected:

Please Login or Register  to view this content.

With a single-item-select listbox this works:

Please Login or Register  to view this content.

[VAer]

Please Login or Register  to view this content.

Thanks, that is perfect.