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 in column "A" 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 is in column "A". 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 (column B). the check box in this case is related to being qualified for a job.
for instance, if I have 2 people (kevin and derrick) 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.