Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm getting this error message %subject% while trying to assign value into the listbox in VBA Excel. The error occurs when writting to column "10" either the "columncount" property is set to 26. the code is: lb_report.ColumnCount = pocet_stlp + 1 If r = 1 Then condition = True If condition = True Then rwrite = rwrite + 1 lb_report.AddItem For s = 1 To pocet_stlp hodnota = ws.Cells(r, CInt(lb_colselected.List(s - 1, 1))).Value lb_report.List(rwrite - 1, CInt(s)) = hodnota Next s End If Thakns for advice |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Could not set the ControlSource property. Invalid property value error | Excel Programming | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Runtime Error 381 Couldn't set list property, invalid array index | Excel Programming | |||
Runtime Error 381 Couldn't set list property, invalid array index | Excel Programming |