|
rosemai 发表于 2013-2-27 20:42
是是是,版主,以后我一定注意!谢谢了!
给你写个完整的- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Address = "$A$4" Then
- Range("A3").Select
- If Range("A3").Value = "" Then
- MsgBox "单号不能为空!"
- Application.EnableEvents = False
- Target.ClearContents
- Application.EnableEvents = True
- Exit Sub
- End If
- With Sheets("明细表")
- i = .Range("A65536").End(xlUp).Row + 1
- .Cells(i, 1).Value = Range("A3").Value
- .Cells(i, 2).Value = Range("B3").Value
- .Cells(i, 3).Value = Range("A4").Value
- .Cells(i, 4).Value = Range("B1").Value
- End With
- Range("A3:A4").ClearContents
- End If
- End Sub
复制代码
三方快递登记高值剔除按钮.zip
(19.05 KB, 下载次数: 5)
|
|