Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange error message when loading a collection with an item of userdefined type
Hi,
I want to store an unknown number of records, read from a txt data, into a Collection. Each record is made of 26 strings, so I defined a user-defined type Record: Const NLines As Long = 26 Type Record Lines(NLines) As String End Type Dim MyRecord As Record I also defined a Collection object to store all the record: Dim List As Collection Set List = New Collection However, when I read a record and then try to load it into List: Data.Add Item:=MyRecord I get this incomprehensible (for me) error message: "Only public user defined types defined in public object modules can be used as parameters or return types for public procedures of class modules or as fields of public user defined types" What's happening? Can you help me? Thanks in advance, Best Regards deltaquattro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error in loading DLL message | Excel Programming | |||
Strange Type Mismatch Error #13 | Excel Programming | |||
type mismatch error when passing collection byRef | Excel Programming | |||
Collection::Item runtime error | Excel Programming | |||
Strange data type error | Excel Programming |