2,462
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Public code As Integer '序号
Public name As String '姓名
Public cardId As String '身份证号
Public huCode As String '户号
Public isHuzhu As String '是否户主
Dim I As Integer
Dim rowIndex As Integer
Dim colIndex As Integer
Dim rowCount As Integer
Dim sequence As Integer
Dim getPerson As PersonClass
Dim hujiDatas As New Collection
For I = rowIndex To 3
Dim person As New PersonClass
person.code = sequence
person.name = Range("B" + CStr(rowIndex)).Value
person.cardId = Range("C" + CStr(rowIndex)).Value
person.huCode = Range("D" + CStr(rowIndex)).Value '
person.isHuzhu = Range("E" + CStr(rowIndex)).Value
sequence = sequence + 1
rowIndex = rowIndex + 1
hujiDatas.Add Item:=person, Key:=person.cardId
Next
For I = 1 To hujiDatas.Count
Set getPerson = New PersonClass
getPerson = hujiDatas.Item(I)
MsgBox p.name
Next