If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Code to allow multi select listboxes

Thread starter Dermot
Start date Jul 25, 2020

Overview Discussion

Dermot

Board Regular

Jul 25, 2020

Dermot submitted a new Excel article:

Code to allow multi select listboxes - Code to allow multi select listboxes

Using the Developer ribbon, Excel allows you to add listboxes and even to make them multi-select, but doesn't give you a way of listing the multiple selections in the worksheet.

If you set your listbox up like this
View attachment 18986
your cell link will just show 0 - basically the listbox breaks.

The code below will fix this by showing the user selections in the column to the right of the list of items in the worksheet, as shown below. All you do is set the listbox up as...