|
楼主 |
发表于 2016-2-14 16:39
|
显示全部楼层
grf1973 发表于 2016-2-14 16:27
那是你的数组没定义对,改成
ARR = Sheets("资料库").Range("a3:d" & Sheets("资料库").[a999].End(3).Row ...
您好,代码是这样的请查看- Private Sub CommandButton1_Click()
- Dim a As Integer
- Dim i As Long
- Dim myControl As Control
- Set d = CreateObject("Scripting.Dictionary")
- ARR = Sheets("资料库").Range("a3:d" & Sheets("资料库").[d999].End(3).Row)
- For i = 1 To UBound(ARR)
- For j = 2 To 4
- d(ARR(i, 1) & ARR(i, j)) = i
- d(ARR(i, 1)) = i
- Next
- Next
- If d.exists(姓名.Value & 项目1.Value) Then CreateObject("WScript.Shell").Popup "该客户已存在!", 1, "提示": Unload Me: Exit Sub
- If d.exists(姓名.Value & 项目2.Value) Then CreateObject("WScript.Shell").Popup "该客户已存在!", 1, "提示": Unload Me: Exit Sub
- If d.exists(姓名.Value & 项目3.Value) Then CreateObject("WScript.Shell").Popup "该客户已存在!", 1, "提示": Unload Me: Exit Sub
- a = Sheets("资料库").[a65536].End(xlUp).Row
- With Sheets("资料库").Range("A" & a + 1)
- .Offset(0, 0).Value = 姓名.Value
- .Offset(0, 1).Value = 项目1.Value
- .Offset(0, 2).Value = 项目2.Value
- .Offset(0, 3).Value = 项目3.Value
- .Offset(0, 4).Value = 电话.Value
- .Offset(0, 5).Value = 开 户 银 行.Value
- .Offset(0, 6).Value = 银 行 帐 号.Value
- End With
- If 类别.Text = "" Or 名称.Text = "" Then
- Else
- With Sheets("明细表")
- i = .[a1].CurrentRegion.Rows.Count + 1
- .Cells(i, 1) = DTPicker1.Value
- .Cells(i, 2) = 类别.Text
- .Cells(i, 3) = 名称.Text
- .Cells(i, 4) = 项目.Text
- .Cells(i, 5) = 摘要.Text
- .Cells(i, 6) = 凭证.Text
- .Cells(i, 7) = 银 行 卡 号.Text
- .Cells(i, 8) = 收入.Text
- .Cells(i, 9) = 支出.Text
- .Cells(i, 10) = 借或贷.Text
- .Cells(i, 11) = 备注.Text
- End With
- End If
- CreateObject("WScript.Shell").Popup "您已保存成功!", 1, "提示"
- Unload Me '卸载 我(窗体)
- End Sub
复制代码 |
|