OOP in vba?

[Harvey]

Hi

I have to declare an object named LegalName that contains three public variable

Class LegalName
Dim Id as Intege
Dim Name as Strin
Dim CRef() as Strin


Can I do something like that in vba? thx

 

[Steve Lang]

Hi Harvey,

Try using a User Defined Type Variable:

At the module level define it:
Private Type udtCat

Color as string

Name as string

Lives as Integer

End Type



Then use it

Sub foo

Dim udtFluffy as udtCat

udtFluffy.Color = "Calico"

etc...

End Sub



HTH and have a great day!



Steve

 

[Jezebel]

You use class modules, same as in VB.