I'm new to VBA and i really stuck with my userform.
I have 16 checkboxes, sometimes people can check one but in other occasions - two,three,four or even all 16 checkboxes can be selected.
So basicly what i need is when i will press the Update button it will copy all data from userform to DataBase sheet with all checkboxes i selected.
All checkboxes have different names, so in DataBase sheet column "R" i will see all names of the checkboxes i copied.
for example if i will check 4 checkboxes that means in DataBase sheet i will see 4 rows with newly copied information, all info will be the same,except column "R" where it should fill the names of the checkboxes.
Sorry if its not very clear, but i couldnt explain it better.
I can't provide the original workbook because it is too big and i can't attach it, so I'm attaching the example workbook but you will get an idea whats going on.
I really appreciate for your help and thanks in advance.