Clear UserForm Multi Select ListBox

Hi

I'm trying to clear a UserForm Multi Select ListBox

This Code works on a UserForm Single Select ListBox

Please Login or Register  to view this content.

but does NOT work on a Multi Select ListBox.

I've resorted to this Code for the Multi Select

Please Login or Register  to view this content.

Is there a more direct way of doing this without iterating through all the elements in the Multi Select ListBox?

Try this.

Please Login or Register  to view this content.

Hi Norie

Apparent no go...get an Error Message "Permission Denied" with this Code

Please Login or Register  to view this content.

Have you populated the listbox via RowSource?

If you have that's why you get the error.

What you could do is clear the RowSource property first.

Please Login or Register  to view this content.

You would of course lose the many advantages of using RowSource.

Actually you can use this if you've used RowSource.

Please Login or Register  to view this content.

Hi Norie

This appears to work

Please Login or Register  to view this content.

Thanks for you help...