Hi,
I've just read a few similar threads but cant seem to work out my problem 
I am using the following code to show only the unique:
Dim rng As Range
Dim Dn As Range
Dim Dic As Object
Set rng = Range(Range("E2"), Range("E" & Rows.Count).End(xlUp))
Set Dic = CreateObject("scripting.dictionary")
Dic.CompareMode = vbTextCompare
For Each Dn In rng
If Not Dn = vbNullString Then Dic(Dn.Value) = Empty
Next
With Me.NJReportedCB
.RowSource = ""
.List = Dic.Keys
.ListIndex = 0
End With
Following the 'NJReportedCB' there are 2 Textboxes: 'NJTelephoneTB' & 'NJEmailB'.
How can I get the 2 Textboxes to auto fill with the corresponding data from the ComboBox selection's row.
I thought this was really simple but i'm struggling and getting stressed 
Any help greatly appreciated.
Thanks,
Cuba
Bookmarks