mit nachstehendem Code fülle ich die Comboboxes in meiner Userform (ohne Duplikate).
Diese Einträge würd ich gern noch sortiert angezeigt bekommen (A-Z).
Private Sub UserForm_Initialize()
Dim oDic As Object, meAr
Dim A As Long
Dim S As Long
For S = 1 To 10 'Variable für Spalten A bis H
Controls("Box" & S).RowSource = ""
Set oDic = CreateObject("Scripting.Dictionary") '
With Sheets("Arten")
meAr = .Range(.Cells(1, S), .Cells(.Rows.Count, S).End(xlUp))
End With
For A = 1 To UBound(meAr)
oDic(meAr(A, 1)) = 0
Next
Controls("Box" & S).List = oDic.keys 'Box1, Box2, Box3, Box4-Box8
oDic.RemoveAll
Next
Set oDic = Nothing
End Sub