XLA and Listbox.rowsource

[Guest]

I am trying to fill a listbox with data from a hidden Add-In Sheet.
I have tried a lot of things:

listbox1.RowSource = ThisWorkbook.Names("NWD").RefersToRange.Address(1, 1, ,
True)

and also

lbox_RowSource.RowSource = "=NonWorkingDays!A1100"

but it is only working, when I declare the property of ThisWorkbook IsAddIn
to false.

Is there a way to get around this limitation?
Thanks in advance,
Sven

 

[Guest]

A workaround might be:

listbox1.List = ThisWorkbook.Names("NWD").RefersToRange.Value

 

[Guest]

Hi Tom,
now I will always get the runtime error 1004 - regardless if the IsAddIn
property is set to true or false.
Even if I try to change the RowSource property via IDE (GUI), I will get a
message, that this is an invalid property value.
Regards,
Sven

---------------------