I have a UserForm with 39 checkBoxes that relate to different assessments that employees may need.
I have a ListBox that imports the assessments currently held by the operative from the worksheet.
The assessments are in column 5 of the ListBox.
The name of the assessment matches the caption name of the CheckBoxes.
is there a way of writing code to automatically checking the CheckBoxes if the caption matches the assessment listed in column 5 of the ListBox?
Any help will be much appreciated.