Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox - Rowsource | Excel Programming | |||
RowSource in ListBox | Excel Programming | |||
RowSource in ListBox | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
listbox rowsource | Excel Programming |