- ©«¤l
- 128
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 118
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- Office2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥|¤t¦¨³£ÊT崃
- µù¥U®É¶¡
- 2010-9-13
- ³Ì«áµn¿ý
- 2017-5-12
|
'°²设 ID.Text¬O"员¤u编号",¥ý对 ID.Text进¦æ§P断,¬O§_¦bd¦C¦s¦b.
Private Sub add_Click()
With Sheets("¤H¨Æ¸ê®Æ")
If Application.WorksheetFunction.CountIf(.Range("d:d"), ID.Text) > 0 Then
MsgBox "员¤u编号¤w¦s¦b!", vbCritical, "错误"
Exit Sub
End If
With .Range("A65536").End(xlUp)
.Range("A2") = no.Text
.Range("B2") = FullName.Text
.Range("c2") = birthday.Text
.Range("d2") = ID.Text
End With
End With
End Sub
'没¦³ªþ¥ó,没¦³验证过«¢.´£问³Ì¦nn¦³ªþ¥ó |
|