Creating user defined objects

[Matt]

Hi All,

I want to create my own object and then in a different module create an
Array of this object. Is there a good reference for the syntax of user
defined objects?

Is this even possible in VBA (I have done this multiple times in .NET,
but I do not think the syntax would be the same)?

 

[Baz]

Looking up "Class" in Access/VBA help should reveal the topic "Program With
Class Modules", which should be enough to get you started if you are already
familiar with the concepts. It's a lot simpler in VBA than it is in VB.Net,
you have few of the ludicrous OO bells-and-whistles that the designers of
..Net decided to confuse us with.

Arrays in VBA are very limited, you can only index them by ordinal number (I
can't remember what VB.Net offers, probably it has some preposterous array
class!). You may find that a Collection object is more suitable.

 

[Matt]

Looking up "Class" in Access/VBA help should reveal the topic "Program With
Class Modules", which should be enough to get you started if you are already
familiar with the concepts. It's a lot simpler in VBA than it is in VB.Net,
you have few of the ludicrous OO bells-and-whistles that the designers of
.Net decided to confuse us with.

Arrays in VBA are very limited, you can only index them by ordinal number (I
can't remember what VB.Net offers, probably it has some preposterous array
class!). You may find that a Collection object is more suitable.

Thanks Baz!!!

 

[Matt]

Looking up "Class" in Access/VBA help should reveal the topic "Program With
Class Modules", which should be enough to get you started if you are already
familiar with the concepts. It's a lot simpler in VBA than it is in VB.Net,
you have few of the ludicrous OO bells-and-whistles that the designers of
.Net decided to confuse us with.

Arrays in VBA are very limited, you can only index them by ordinal number (I
can't remember what VB.Net offers, probably it has some preposterous array
class!). You may find that a Collection object is more suitable.

Thanks Baz!!!

..NET objects are annoying - too many ways to do the same thing

 

[Baz]

My sentiments precisely!