Populating a Worksheet with values selected from a Dynamic Listbox

I don't know how to populate a worksheet with the values selected from a userform listbox that has been populated dynamically from a named range.

I can create a copy of the Master worksheet and name it based on the dropdown rooms, and I have got the listboxes to generate a

checkbox list correctly, but am now unsure as how to get this information back onto the newly created sheet, as I am unsure what name each checkbox will have.

Also can you pick up the text label of a checkbox which is set to true to use that as well.

Any help would be appreciated. I have tried to upload my spreadsheet but the attachments manager says I don't have permission

let say you have some CheckBoxes and one CommandButton1 - try below code for test it

Please Login or Register  to view this content.

p.s. sorry it is not an answer for your question - I will think about it a bit ... ;-)

I think you will do not need to know any name - your listboxes with style combobox have the same proberty for both ListStyle - so you always are able to refer to index of item
put new userform - then listbox and 1 commandbutton then copy below code for test what I'm talking about

Please Login or Register  to view this content.