PDA

View Full Version : LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING



DeanP
12-10-2018, 08:43 PM
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
12-10-2018, 09:57 PM
Hi DeanP!
when use a named range in another sheet, filename must be added like this: "test1.xlsm!named"
Please refer to the attachment.