I was wondering if there is a way, in VBA to create my own object type. I know in java I would have a class with a constructor to generate the object. Basically what I'm doing is I have a list of products, each product has a yield, repeat repair, Turn Around Time, Backlog and output. Rather than creating arrays for each I want to create objects of type "product" so I could do something like this:
product1.yield = 42.5
product1.backlog = 102
product2.yield = 50.4
.....
......
this way, if I have to add a product later it will be much easier than having to adjust the arrays.
So, if there is a way to do that in Excel, how would I do it?
product1.yield = 42.5
product1.backlog = 102
product2.yield = 50.4
.....
......
this way, if I have to add a product later it will be much easier than having to adjust the arrays.
So, if there is a way to do that in Excel, how would I do it?