|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Private Sub Worksheet_Change(ByVal T As Range)
If T.Row > 1 And T.Column = 1 Then
If T.Count > 1 Then Exit Sub
If T.Value = "" Then Exit Sub
If T.Row = 2 Then
T.Offset(, 1) = Format(Date, "yyyymmdd") & T.Value & Format(1, "00")
ElseIf T.Row > 2 Then
zf = Left(T.Offset(-1, 1), 8)
rq = Format(Date, "yyyymmdd")
If Val(zf) <> Val(rq) Then
T.Offset(, 1) = Format(Date, "yyyymmdd") & T.Value & Format(1, "00")
Else
sl = Len(T.Offset(-1, 1))
sl_1 = Len(T.Offset(-1))
zf_1 = InStr(T.Offset(-1, 1), T.Offset(-1)) + sl_1
xh = Mid(T.Offset(-1, 1), zf_1, sl - zf_1 + 1)
T.Offset(, 1) = Format(Date, "yyyymmdd") & T.Value & Format(Val(xh) + 1, "00")
End If
End If
End If
End Sub
|
|