|
发表于 2013-4-16 14:51
|
显示全部楼层
本楼为最佳答案
添加按钮代码略改下,数字超长的问题- Private Sub 添加确认_Click()
- Dim r As Long
- Dim c As Range
- If xm.Text = "" Then MsgBox "姓名为空": Exit Sub
- With Sheets("客户基本信息")
- Set c = .[c:c].Find(xm.Text, , , 1)
- If Not c Is Nothing Then
- If MsgBox("用户已添加,是否继续添加!", vbInformation + vbYesNo, "系统提示") = vbNo Then Exit Sub
- End If
- r = .Range("A1").End(xlDown).Row + 1
- .Cells(r, 1) = rq.Text
- .Cells(r, 2) = "'" & khbh.Text
- .Cells(r, 3) = xm.Text
- .Cells(r, 4) = xb.Text
- .Cells(r, 5) = nl.Text
- .Cells(r, 6) = sr.Text
- .Cells(r, 7) = dh.Text
- .Cells(r, 8) = zy.List
- .Cells(r, 9) = dz.Text
- End With
- End Sub
复制代码 |
|