XLA and Listbox.rowsource
 

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

XLA and Listbox.rowsource
 

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

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