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

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

--
Regards,
Tom Ogilvy


"Dolemite" wrote in
message ...

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

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


--
Dolemite
------------------------------------------------------------------------
Dolemite's Profile: http://www.excelforum.com/member.php...o&userid=26136
View this thread: http://www.excelforum.com/showthread...hreadid=501252