VBA Classes and Objects

S

Spy king

Adept
Hello!

I am trying my hand at some coding after a while, and am not to familiar with VBA, did some C++ at school.


I have a Struct called Prizes
Code: 
Type Prize
Postion(1 To 10) As Long
Count As Long
RowIndex As Long
End Type

I want to initialize this Struct as various categories and then access them across diff subs.. How should I go about that? Or am I approaching the whole thing from the wrong direction?


So basically I have Age, and Group and few other categories


Code: 
Dim AgeCat1 as Prize
With AgeCat1
    .Count = 1
    .Postion(1) = 2500
    .Postion(2) = 1500
    .Postion(3) = 750
End With

How Can I access these members from all other subroutines?

Regards!
 
Back
Top