You should add a class module into the project.
choose project and click the add class module submenu.
Then please cofigure the property of the class .
you can declare the members and methods or property
'it's members
private mAmericanId as string
private mAmericanLen as integer
private enum mAmericanColor
green
red
.
.
.
end enum
....
....
' properties
public property let PigId ( vPigId as string)
mpigId = vPigId
end property
public property get PigId ( ) as string
mpigId = vPigId
end property
.....
'methods
public sub savetodb()
'you can add code to save the data to the table or database
end sub
.....
You add any method you want like to check the data and etc.