Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,629
- Office Version
- 365
- 2016
- Platform
- Windows
I have a dynamic range of cells in a worksheet that I have given the name "nrngUXDump". This named range of cells is to form the contents of a listbox (".lbx_collections") on my userform "IFM_Title"
This is the code I am using. It is giving me an error - "Could not set the List property. Invalid property array idex" - with the line in red.
nrngUXDump refers to a range of U2:X14 in worksheet ws_dump. I assessed the names in the current workbook and it is there amd I believe appears to have all the data.
This is the code I am using. It is giving me an error - "Could not set the List property. Invalid property array idex" - with the line in red.
Rich (BB code):
...
With IFM_Title
.tbx_titlecnt.Value = WorksheetFunction.CountIf(ws_dump.Columns(1), txt_model)
.tbx_checkedcnt.Value = WorksheetFunction.CountIf(ws_dump.Columns("W"), "YES")
.tbx_collectedcnt.Value = WorksheetFunction.CountIf(ws_dump.Columns("V"), "OK")
With .lbx_collections
.columnCount = 4 'collected, title, primary, model checked
.ColumnWidths = "15,96,42,15"
.List = "nrngUXDump"
End With
End With
...
nrngUXDump refers to a range of U2:X14 in worksheet ws_dump. I assessed the names in the current workbook and it is there amd I believe appears to have all the data.