|
本帖最后由 damnedvi 于 2019-10-22 21:09 编辑
比如老师类 private name as string
private p_students as Collection '不知道这个是不是这样写,一般的java之类的可以定义一个student的List之类的
....
Public Property Get students() As Collection
If p_students Is nothing Then
Set p_students = New Collection
End If
set students = p_students
End Property
Function add_student(stu As Student) 'Student为自定义的类
If p_students Is nothing Then
Set p_students = New Collection
End If
p_students .Add stu
End Function
--------------------------------------
测试
Sub test()
Dim teacher As Teacher
Dim stu1, stu2 As Student
Dim s As String
Dim col As Collection
Set stu1 = New Student
stu1.year = "2019"
stu1.name = "张三"
Set stu2 = New Student
stu2.year = "2019"
stu2.name= "李四"
Set teacher = New Teacher
teacher.name = "李老师"
Call teacher.add_student(stu1)
Call teacher.add_student(stu2)
end sub
因为临时帮一个朋友弄一点东西,没啥vba的基础,问下大神有没例子参考下这类问题vba咋解决,VBA中集合类只有 collection 和 字典么?
|
|