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
Bookmarks