I have a large amount of data in columns A, B, & C in sheets("LOC").
Columns A & B have many duplicate entries, which I do not want to
delete. Combobox1 displays column A data. Combobox2 displays column
B. Currently, with the code below, I can make a selection in Combobox1
and it will auto populate Combobox2 with the matching data (in relation
to what's been selected in Combobox1).

My trouble is that I do not want to see duplicates entries in either
Comboboxes when I select the drop down button if that is possible.

Here's my code so far.....Thank you !

Private Sub Combobox1_click()
Dim sData As String
sData = Combobox1.Value
Combobox2.RowSource = ""
Combobox2.Clear
For Each cell In Worksheets("LOC").Range("A2:A3908")
If LCase(cell.Offset(0, 1).Value) = LCase(sData) Then
Combobox2.AddItem cell.Value
End If
Next
End Sub


Oreg


--
Oreg
------------------------------------------------------------------------
Oreg's Profile: http://www.excelforum.com/member.php...fo&userid=9195
View this thread: http://www.excelforum.com/showthread...hreadid=475420