populate control from named range stored in addin

[Admin]

This should work

    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.

[MrBlackd]

I will take a shot and I will report back.
Thanx !!!


Edit:

It seems to be working great with named ranges and the isaddin = false issue is gone. the userform loads properly and the listbox and combobox populate properly

There is only one disadvantage, if the named range consists of 1 cell only then the listbox does not show anything.
If it can be overcome then it will be perfect.