|
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 And Target <> "" Then
Target.Offset(0, 1) = Format(Now(), "yyyy-m-d")
ElseIf Target.Column = 2 Then
Target.Offset(0, 1) = ""
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
S = S + 1
On Error Resume Next
If Target.Count = 1 And Target.Column = 2 And Target.Row >= 2 Then
If Target <> "" Then
For I = Target.Row - 1 To 2 Step -1
If Range("B" & I) <> "" Then S = S + 1
Next I
Target.Offset(, -1).NumberFormatLocal = "@"
Target.Offset(, -1) = Format(S, "00")
Else
Target.Offset(, -1) = ""
End If
End If
|
|