Private Sub Worksheet_Change(ByVal TargetAs Range) On Error Resume Next For Each c In Target With c .AddComment .Comment.Text Text:=&quot;&quot; & Now End With NextEnd Sub如需要在j4:p5000范围内单元格中实现此功能,则改成:Private Sub Worksheet_Change(ByVal TargetAs Range) On Error Resume Next For Each c In Target If c.Column > 9 And c.Column < 17 And c.Row > 3 And c.Row <5001 Then With c .AddComment .Comment.Text Text:=&quot;&quot; & Now End With End If NextEnd Sub
共 1 个关于本帖的回复 最后回复于 2013-7-11 15:09