I need help to make the ComboBox9 is filled with the ComboBox8 information complement.
For example, if in ComboBox8 in column A2 is the first name "Mike", and it is selected, in ComboBox9 in the same row and corresponding column, which would be B2, is the last name "Jones", be filled in ComboBox9