Delete values based on deselected checkboxes in userform

Hi

I have a macro which will automatically open a userform upon opening (see screenshot in attached workbook). I want these checkboxes all to be checked when opening the userform. That way the user has to deselect the person who is absent.

Secondly I want a macro to delete all names (of whom the box is unchecked) in the "updated_deck" sheet, and this when the user clicks the "next" button on the userform.

This the tricky part of the macro I have to create, so your help is highly appreciated.

Kind regards,
Tino XXL

Originally Posted by Tino XXL

Hi

I have a macro which will automatically open a userform upon opening (see screenshot in attached workbook). I want these checkboxes all to be checked when opening the userform. That way the user has to deselect the person who is absent.

hi
try this, hope it helps you

Please Login or Register  to view this content.

hi,
for part 2, maybe someone else can help us!

add a CommnadButton in yr UserForm and add this piece of code.
well...it could be shorter and nice but I do not know how to make it this way! ))
please continue it for all yr cases and see if it helps you.

Please Login or Register  to view this content.