|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim i&, j&, ss$
- If Target.Row < 7 Then Exit Sub
- If Target.Column = 5 Then
- If Target.Count > 1 Then Exit Sub
- If Target.Value <> "" Then
- Target.Offset(0, 16).Value = ((2012.08 - Target.Value)) \ 1
- Else
- Target.Offset(0, 16).Value = ""
- End If
- End If
- If Target.Column = 20 Then
- If Target.Count > 1 Then Exit Sub
- If Target.Value = "" Then
- Target.Offset(0, 2).Value = ss
- Exit Sub
- End If
- For j = 1 To Len(Target.Value)
- For i = 0 To 9
- If InStr(Mid(Target.Value, j, 1), i) > 0 Then
- ss = ss & Mid("零一二三四五六七八九", i + 1, 1)
- Exit For
- End If
- Next
- Next
- If Len(ss) > 0 Then
- Target.Offset(0, 2).Value = ss
- End If
- End If
-
- If Target.Column <> 1 Then Exit Sub
- If Target(1) <> "" Then
- For i = 1 To Target.Rows.Count
- Target(i).Offset(-1, 20).Copy Target(i).Offset(0, 20)
- Target(i).Offset(-1, 21).Copy Target(i).Offset(0, 21)
- Next i
- End If
- End Sub
复制代码 |
|