This should work

Code:
    Dim a
    
    a = ThisWorkbook.Worksheets("DATA").Range("myTypes").Value2
    
    With ComboBox1
        .List = a
    End With
but not sure why the rowsource property is not working.