Linked comboboxes - select either one

[Nogslaw]

I have 2 columns in sheet 1. Column A contains associate names, and column B contains their ID#'s. I have a userform with 2 comboboxes, one for names and one for ID's. I would like to be able to select either box and have the other autoselect the corresponding information. Currently, I have it working if I select something out of the first box by using a vlookup command. However, I cannot figure out how to do the 2nd box. I have tried a match function, but couldn't get it to work consistently.

 

[Andrew Poulsom]

Say you have 2 lists name List1 and List2, being the RowSource property for ComboBox1 and ComboBox2 respectively. Then you can use this code:

Dim Disabled As Boolean

Private Sub ComboBox1_Change()
    If Disabled Then Exit Sub
    Disabled = True
    ComboBox2.Value = Range("List2").Cells(ComboBox1.ListIndex + 1, 1)
    Disabled = False
End Sub

Private Sub ComboBox2_Change()
    If Disabled Then Exit Sub
    Disabled = True
    ComboBox1.Value = Range("List1").Cells(ComboBox2.ListIndex + 1, 1)
    Disabled = False
End Sub