Code to populate text boxes based on value of ComboBox1

[matrixpom]

Good day all,

I have a worksheet with a list of personnel names, Title, contact numbers & their qualifications, I also have a userform that I need to populate based on the value of "ComboBox1" (this ComboBox is populated from a named range) so if "Joe Black" is selected I need it to fill the remaining 3 TextBoxes with their Title, contact number & their qualification. I have attached a small example & as always any assistance is greatly appreciated, thank you all once again & have a great day! - Marco

[nilem]

Hi Marco
try this (with using a 4-columns combobox)

[matrixpom]

Спасибо Nilem,

Работает отлично - Марко

[nilem]

Вау!
На здоровье