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)?

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 wrote:
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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)?
> >

Thanks Baz!!!

Baz wrote:
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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)?
> >

Thanks Baz!!!

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

My sentiments precisely!

"Matt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
>
> .NET objects are annoying - too many ways to do the same thing
>