| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox getting error 380 cannot set the rowsource property
I'm trying to set the rowsource for a listbox to use a named range in a
workbook that's external to the workbook where the listbox is defined. Dim wb As Workbook Set wb = Workbooks("Budget Account Table.xls") lbPAAccount.RowSource = wb.Names("AccountAbbrev").RefersTo The "Budget Account Table.xls" is open in the current workspace. Do I also need to Activate "Budget Account Table.xls"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RowSource in Property Dialog | Excel Programming | |||
| Rowsource Property | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
| Could not set the RowSource property | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Threaded Mode
