can I set my own object type like in java

[ribbs2521]

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?

 

[VoG]

You can define your own data type like this

Type salesResults
    spring  As Single
    summer  As Single
    autumn  As Single
    winter  As Single
End Type

You can then define a variable as that data type

Dim MyStore As salesResults

and assign values to it like

With MyStore
    .spring = 1000
    .summer = 250
    .autumn = 700
    .winter = 200
End With

 

[ribbs2521]

That's it, thanks a lot.

 

[ribbs2521]

actually, one more thing, is there any way to initiate these as 0 by default. It appears that, like normal variables, these static variables are not initiated as 0 or "". I get an error saying that productx.output = empty since that product wasn't in the pivot table I'm looking at.

 

[VoG]

actually, one more thing, is there any way to initiate these as 0 by default. It appears that, like normal variables, these static variables are not initiated as 0 or "". I get an error saying that productx.output = empty since that product wasn't in the pivot table I'm looking at.

I think that they should be 0 or "" or Nothing by default. Perhaps you need to post your code.

 

[ribbs2521]

That's odd, since you said that, I tried it again and it works fine. I even ran it a few more times and it works fine still. Must have been I fluke I guess. Thanks again for your help.