|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 保存()
Application.ScreenUpdating = False
Dim n%, m%, x%, y%, k%
On Error GoTo 100
If Sheets("数据库").[A:A].Find([A3]) = [A3] Then
MsgBox "此单已经保存过了!"
Else
100:
If [B3] = "" Or [I3] = "" Or [J3] = "" Then MsgBox "信息没有填写完整,不能保存!": End
m = Sheets("数据库").[A65536].End(xlUp).Row + 1
With Sheets("数据库")
.Cells(m, "A").Value = [A3] '单号
.Cells(m, "B").Value = [B3] '日期
.Cells(m, "C").Value = [C3] '产线
.Cells(m, "D").Value = [D3] '长
.Cells(m, "E").Value = [E3] '宽
.Cells(m, "F").Value = [F3] '厚
.Cells(m, "G").Value = [G3] '支数
.Cells(m, "H").Value = [H3] '平米数
.Cells(m, "I").Value = [I3] '仓库
.Cells(m, "J").Value = [J3] '库存方向
End With
MsgBox "保存成功!"
End If
ActiveWorkbook.Save
Application.ScreenUpdating = True
End Sub
|
|