Hi,
try
Code:Private Sub UserForm_Initialize() Dim v, e With Sheets("maintenance").Range("c2:c500") v = .Value End With With CreateObject("scripting.dictionary") .comparemode = 1 For Each e In v If Not .exists(e) Then .Add e, Nothing Next If .Count Then Me.ComboBox19.List = Application.Transpose(.keys) End With End Sub
HTH