|
1.改为工作薄事件,2.因为触发事件的局限性,暂时没想到解决方法
- Dim oldvalue
- Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
- If Target.Comment Is Nothing Then
- Target.AddComment Format(Now(), "mm/dd hh:mm:ss") & " 原内容: 空白 修改为: " & Target.Value
- Else
- oldcomment = Target.Comment.Text
- Target.ClearComments
- Target.AddComment Format(Now(), "mm/dd hh:mm:ss") & " 原内容: " & oldvalue & " 修改为: " & Target.Value & Chr(10) & oldcomment
- End If
- Target.Comment.Shape.Width = 300
- End Sub
- Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
- oldvalue = Target.Value
- End Sub
复制代码 |
|