Sub Macro1() ' ' Macro1 Macro ' 宏由 USER 录制,时间: 2009-10-17 Dim b, a With ActiveCell If .Comment Is Nothing Then
a = InputBox("请输入批注内容", "填写批注") .AddComment .Comment.Visible = False .Comment.Text Text:=a Else b = .Comment.Text a = InputBox("此单元格已有的批注", "请输入批注内容", b) .Comment.Delete .AddComment .Comment.Visible = False .Comment.Text Text:=a End If End With End Sub |