Placing a user defined type in a Collection

V

vivmaha

Hi,

I'm trying to make a collection in which i place variables of a type that i
defined.
I keep getting an error message. What is the problem?

The error message:
"Compile error: Only user-defined types defined in public object modules can
be coerced to or from a cariant or passed to late-bound functions"

The code (and where the error is thrown):
Public Type myType
stuff As Integer
End Type

Sub main()

Dim box As Collection
Set box = New Collection

Dim myVar As myType
myVar.stuff = 1

box.Add myVar '<-THIS IS WHERE I GET THE ERROR

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strange error message when loading a collection with an item of userdefined type 2
Timescalevalue update gives error 1101 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
User-defined type collection in class module 2
compiler error: public object module 2
ItemAdd and FolderAdd events problem with Public Folders 0
Unable to add user-defined data types to a collection 3
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0

Top