父类:
Public Class ClsParent
Private mChild As ClsChild
Private mName As String
Public Sub New()
mChild = New ClsChild(Me)
End Sub
Public Property Child() As ClsChild
Get
Return mChild
End Get
Set(value As ClsChild)
mChild = value
End Set
End Property
Public Property Name As String
Get
Return mName
End Get
Set(value As String)
mName = value
End Set
End Property
End Class
Public Class ClsChild
Private mParent As ClsParent
Private mName As String
Public Sub New(ByRef vParent As ClsParent)
mParent = vParent
End Sub
Public Property Parent() As ClsParent
Get
Return mParent
End Get
Set(value As ClsParent)
mParent = value
End Set
End Property
Public Property Name() As String
Get
Return mName
End Get
Set(value As String)
mName = value
End Set
End Property
End Class
Module Module1
Sub Main()
Dim Obj As New ClsParent
Obj.Name = "Parent Object."
Obj.Child.Name = "Child Object."
Console.WriteLine(Obj.Child.Parent.Name)
Console.WriteLine(Obj.Child.Parent.Child.Name)
Console.ReadKey()
End Sub结果:
本文展示了一个使用VBA编写的简单类模块示例,包括一个父类和一个子类。父类包含一个子类类型的属性,并在构造函数中实例化子类;子类则持有父类的引用。通过这个例子,演示了如何在VBA中实现类之间的继承和关联关系。
571

被折叠的 条评论
为什么被折叠?



