WorkSheet List Box Multiple Selection by Macros

Dear All,

I have a list box in an Excel sheet (with the selection type MULTI). I have inserted a check box by the name 'Select All'. Once the check box is checked, I would like all items in the List box to be selected.

The code to select one item at a time is this:

Please Login or Register  to view this content.

This code only selects one item at a time. So, at the end of the code, the last item of the list is selected.

Can anyone help me with the code to select all items at the same time?

Thanks in advance.

Regards,
Karan

Hi Karan
perhaps this example will help you

Hi Nilem,

Thank you for your reply.

However, the code mentioned in your file is applicable for ActiveX Controls. On the other hand, I have used Form Controls on the Sheet.

Regards,
Karan

Do you have a solution for Form Controls on the Sheet (not ActiveX Controls)?

The code would be something on these lines:

Please Login or Register  to view this content.