Copying values from one sheet and writing to a different sheet with a combobox

[sved]

Hello all, im new to vba and need some assistance writing some code that will search a column on one sheet for the name “manager” and return to a combobox the first name which is in the next cell to the right of manager and the last name which is in the next cell over from that. In the combobox the user can choose from the list of the managers listing their first and last name, then when clicking next on the form the selected manager name would be written into the designated cell on the designated sheet.
Ive been reading through forums for a few days now and haven’t found anything with this functionality. Any assistance would be appreciated. Thanks.