Combo Box Matching text
Posted by Lucky on December 07, 2001 7:18 AM
I am trying to tell a combobox1 that if the text is "123" then change the text in combobox 2 to "abc" and vice versa. I achieved that with the following (the cell referenced is the start of each list)
Private Sub ComboBox2_Change()
If ComboBox2.Text = (ActiveSheet.Range("a1")) Then
ComboBox3.Text = (ActiveSheet.Range("b1"))
End If
Private Sub ComboBox3_Change()
If ComboBox3.Text = (ActiveSheet.Range("b1")) Then
ComboBox2.Text = (ActiveSheet.Range("a1"))
End If
Exit Sub
The lists are over one hundred cells long, and instead of repeating the above code a hundred times I was wondering if I could simply compare the ranges/lists.
It is ordered so that a1 matches with b1, a2=b2, c3=c3....etc
Hope this is clear!