how to fill the Listfillrange, in an activeX combobox with an dynamic range

[TimvanSprang]

I have multiple comboboxes, all of them need to be filled with the same set of data in an collumn an another sheet.

Normaly I would use a range in the Listfillrange box of the properties window.

For example Sheet1!A1:A25

But in this case the list will expand or shorten in the future and I don't want to have to change all my ranges in the comboboxes.

I tried using a dynamic named range, but somehow this doesn't work. If I type the name of this dynamic range into the listfillrange box of the properties window it's disapears after pressing enter, leaving the box empty.

Has anyboy an idea to fix this for me?

Thanks a lot