Public Sub 技巧5_029()
Dim myFile As String, myFileName As String
Dim myRange As Range
Set myRange = ThisWorkbook.Worksheets("Sheet1").Range("B1") '指定放置图表的单元格
myFileName = "myChart.jpg" '指定图表图像文件名
myFile = ThisWorkbook.Path & "\" & myFileName '指定代完整目录的图表图像文件名
On Error Resume Next
myRange.Comment.Delete '删除原有的批注
On Error GoTo 0
With myRange.AddComment.Shape
.Height = 300
.Width = 500
.Fill.UserPicture myFile
End With
myRange.Comment.Visible = False
Set myRange = Nothing
End Sub
可以试下以上代码