| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime Error 381 Couldn't set list property, invalid array index
I opened a 97 spreadsheet in 2003 and now each time a user form is
initialized a runtime error comes up in the following line in the vba code: ComboDeptNum.List = Sheets("Definitions").Range("$J$1:$I$12") It is the same thing if I specify a named range: ComboDeptNum.List = Sheets("Definitions").Range("DeptList") This exact same codes works fine in 97 and the security is set to low in 2003. The number of columns is set propoerly but the list box just won't load values. I'm a newbie to Excel vba but have more experience with Access and never saw this 381 in Access. Thanx in advance for help on this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime Error 1004 Unable to set the top property of the picture c | Excel Discussion (Misc queries) | |||
| runtime error 434, object does not support this method or property | Excel Discussion (Misc queries) | |||
| Compile Error: Wrong arguments or Invalid property | Excel Discussion (Misc queries) | |||
| Propblem setting OnAction property at runtime | Excel Programming | |||
| RunTime Error "1004" QueryTable is Invalid | Excel Programming | |||
Hybrid Mode
