Checkboxes to create lists

Hi All,

Can anyone suggest a way to create a list in a cell which is generated by checking checkboxes in a userform. Something along the line of (not in syntax!):

for cell b3 - if checkbox 1 == true - inset "word1", if checkbox 2 == true - inset "word2" etc.

Essentially what I'm after is to have 10 checkboxes to create a list of the checked items in a cell on pressing the submit button.

thanks for any help!!

Place this code in a command button on your userform.
Results in column "A"

Please Login or Register  to view this content.

Hi Mick,

thanks for your response, but the debugger is finding a problem with line 6 of your code (not sure what to amend in relation to my sheet) and I think this is going to be easier with a multi-select list box on second thought.

However,

not sure how to get the selected options to output into a cell. I'm trying the code in the submit button sub which is working for all combo boxes and text fields but simply doesn't output the results of the list box for some reason:

We're looking at row 16 (listbox1)

Please Login or Register  to view this content.

any thoughts?

You need to set your listbox to "Multiselect", and using code basically as below, place the selected items on the sheet.

Please Login or Register  to view this content.

Hi Mick,

not 100% on what would need to be edited in your code to refer to my data, I've guessed and swapped a few things out but returns an error each time.

Below is the full UserForm code so that you can see what I'm working with and trying to achieve.

Please Login or Register  to view this content.

Don't worry Mike, I've sussed it :D Thanks very much for your input anyway!

Please Login or Register  to view this content.

Good news !!!
Regrds Mick