class/struct functionality in VBA?

[Dolemite]

it has been a while so I will apologize for my terminology...

I remember in C++, you had the ability to create classes and/or structures that encapsulated data about one particular thing.
Eg. if I have a variable named house, then defined within that were different "categories" such as appliances, rooms, etc.. And to access appliances you would do something along the lines of
house.appliances = 5
or you could setup appliances like an array:
house.appliances(1) = dishwasher
house.appliances(2) = fridge

Is there something along these lines in VBA that I can use? Arrays could suffice but would rather not. I have quite a few classifications/catgories and am trying to keep the code form getting too hairy with indexes. I apologize if I am not making this clear enough. Any help would be greatly appreciated! Thanks

[Tom Ogilvy]

http://www.microsoft.com/technet/pro...art2/ch09.mspx

--
Regards,
Tom Ogilvy


"Dolemite" <[email protected]> wrote in
message news:[email protected]...
>
> it has been a while so I will apologize for my terminology...
>
> I remember in C++, you had the ability to create classes and/or
> structures that encapsulated data about one particular thing.
> Eg. if I have a variable named house, then defined within that were
> different "categories" such as appliances, rooms, etc.. And to access
> appliances you would do something along the lines of
> house.appliances = 5
> or you could setup appliances like an array:
> house.appliances(1) = dishwasher
> house.appliances(2) = fridge
>
> Is there something along these lines in VBA that I can use? Arrays
> could suffice but would rather not. I have quite a few
> classifications/catgories and am trying to keep the code form getting
> too hairy with indexes. I apologize if I am not making this clear
> enough. Any help would be greatly appreciated! Thanks
>
>
> --
> Dolemite
> ------------------------------------------------------------------------
> Dolemite's Profile:
http://www.excelforum.com/member.php...o&userid=26136
> View this thread: http://www.excelforum.com/showthread...hreadid=501252
>

[Dolemite]

Thank you very much...I will check that out and see what I can do.