D
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
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