I am working on a tool and need to accomplish several things using the checkbox form control. I have a questionnare that needs to be filtered by functional role so that the appropriate person can complete the appropriate questions and not have to view the entire list.

I have assigned roles to each question by entering IT, HR, FM, or PS in the next column. I can use autofilter to show just the questions for each role or multiple roles but I want the form to be easy for the user so checkboxes would be a better solution. The checkboxes should allow the user to select one or multiple roles. Additionally, the user should be able to uncheck a role checkbox to hide the associated questions if he/she makes an error in selecting his/her role.

Please help. I have very little knowledge of VBA script.