I've got a userform for input of data. I've got a combobox that picks up employee names from sheet1 A1:A20. but as i need they're payroll number which is in B1:B20. how to i get the combobox to link the employee name in A1:A20 to his employee number in B1:B20 and add that number to a textbox on the userform ?