|
发表于 2011-10-18 22:42
|
显示全部楼层
本楼为最佳答案
本帖最后由 zjdh 于 2011-10-18 22:49 编辑
这容易,UserForm4的宏改为:
Private Sub CommandButton1_Click()
Dim i4, j41, j42 As Integer
With UserForm3.ListView2
i4 = .SelectedItem.Index
For i = 1 To 8
.SelectedItem.SubItems(i) = Controls("TextBox" & i + 1) '这儿简化一下
Next
End With
N = Sheet2.Cells(i4 + 1, 4)
For j41 = 1 To 9
Sheet2.Cells(i4 + 1, j41).Value = Me.Controls("Textbox" & j41).Value
Next
Sheet2.Cells(i4 + 1, 4) = N
UserForm4.Hide
'----------------------------------------------
With Sheet1
ARR = .Range("A2:D" & .Range("A65536").End(3).Row)
For i = 1 To UBound(ARR)
If ARR(i, 2) & ARR(i, 1) = TextBox9 & TextBox2 Then
.Range("D" & i + 1) = TextBox8
Exit Sub
End If
Next
.Range("A65536").End(3)(2) = TextBox2
.Range("A65536").End(3).Offset(0, 1) = TextBox9
.Range("A65536").End(3).Offset(0, 2) = TextBox3
.Range("A65536").End(3).Offset(0, 3) = TextBox8
End With
MsgBox "没有该项供应商本商品记录,已添加!"
End Sub
|
|