Return the number of selected items from a listbox

Cross Posted:
https://www.mrexcel.com/forum/excel-...s-listbox.html

When a user clicks the submit button all information from the form is transferred to the tab in my workbook.

The part of this I am having trouble with is the count of selected items from a 3 multiselect listboxes. Each listbox needs a separate count going to a different cell.

Start of the transfer:

Please Login or Register  to view this content.

The last bit of code needs to tranfere the below 3 Listboxes:

ListBoxAffiliates
ListBoxBOLT
ListBoxDTC


Cells they need to feed to on the same tab:
K4
K5
K7

You need to attach the sample workbook.