LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING

[DeanP]

The ListFillRange property in my combobox just won't work! The list is in another sheet in the same workbook in a named range.

In my combobox (active x) I have tried all the different suggested solutions that I could find, but nothing work. When clicking on the arrow in the box absolutely nothing happens.

Any suggested solutions?

[大灰狼1976]

Hi DeanP!
when use a named range in another sheet, filename must be added like this: "test1.xlsm!named"
Please refer to the attachment.