Linking checkbox to cell based on combo box choice

Good morning,
I have been working on several projects and one keeps me up at night trying to figure out what type of script I need to write. I have a list of names that will be changing based on other things going on. I have a userform with both a combo box and a check box. combo box already updates with anyone that active. What I am trying to do is based on the name I select from the combo box, I want the check box to link to the cell to the right . the check box in this case is related to being qualified for a job.
for instance, if I have 2 people (Kevin and Test) and kevin is qualified, derrick is not. I would like when I select kevin under the combo box that the check box will be checked (because the cell to the right of kevin is true), but I could unselect the checkbox to change the cell's value.

The best I can think of is doing a vlookup like I have done in other areas and adding the linking to the cell option after the lookup. I'm not sure how to write it. Any help would be appreciated.

If I did it right, there should be an attachment to show what I have so far and the big red button is what I am working on.

awesome! I haven't worked with "option explicit" before so that's why I wasn't even thinking that way. now I see it is updating just fine, just one issue. If test dummy is qualified "true" on something and you re-open that userform, it shows it as blank still. I want to be able to visually see on the userform if they are qualified or not. aka, If test dummy lost his qualification I want to be able to make it go false without clicking the checkbox twice. It should already show the checkbox checked and I can just uncheck it.

Is this possible? maybe a code for the combobox_change to update the value of the checkboxes?

Thank you again!

I figured it out.

Please Login or Register  to view this content.

Thank you so much!