XLA and Listbox.rowsource
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
---------------------
"Tom Ogilvy" wrote:
A workaround might be:
listbox1.List = ThisWorkbook.Names("NWD").RefersToRange.Value
--
Regards,
Tom Ogilvy
"Sven" wrote:
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!A1:D100"
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
|