What I'm trying to do is I have a combo box that gets a list of names from another sheet and I have each name linked to a named range on the worksheet. This is so the user can select a name from the combo box and then it takes them right to that person's information on the same page so they do not have to scroll down. This works fine. I have the links hard coded into the ComboBox change function like this:

Private Sub ComboBox1_Change()

Case Is = "Beechy, Mahlon"
Range("C22").Select
Case "Beighley, David"
Range("C33").Select

Case Else
Exit Sub
End Select

End Sub

However I added code for a userform that adds an employee to the list of employees and it shows up into the combo box, but I don't know how to link to it.

The problem I'm having is I don't know that I can dynamically insert code into the ComboBox1_Change() function. And I'm not sure how else I would be able to do this.

Any ideas of how to make this work when an employee is added without hard coding the value each time I add an employee would be great!

Thanks,

Mickie DeVries