|
ht094156 发表于 2014-7-4 20:28
这个很麻烦么
就当成是其中一个吧
代码综合后如下图,测试一下看看
没见你有操作描述,只有看代码来猜,,有可能与你的要求有点不同
- Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
- If Target.Cells(1, 1).Column = 1 Or Target.Cells(1, 1).Column = 8 Then Call XieRu(Target.Cells(1, 1).Column, Target)
- End Sub
- Private Sub XieRu(ByVal Inx As Byte, ByVal MyTarget As Range)
- Dim Arr(1 To 8), C As Range
- Arr(1) = Format(Now, "yyyy-mm-dd hh:mm:ss")
- Arr(8) = "=人员!B2 "
-
- For Each C In MyTarget
- If C.Column = Inx Then
- If C.Value = "" Then
- C.Offset(0, 1).Value = ""
- Else
- C.Offset(0, 1).Value = Arr(Inx)
- End If
- End If
- Next
- End Sub
复制代码 |
|