[RESOLVED] Automatically change textbox data accourding to combobox selected Item

[westconn1]

rar should be acceptable but most will not open

i tested in your file

Private Sub cboName_Click()
txtEmployeeNumber.Value = Worksheets("Sheet1").Cells(cboName.ListIndex + 2, 2)
End Sub

this works for me, you have the name for your combobox incorrect, in the OP