Sub TEST()
Filename = Application.GetOpenFilename(fileFilter:="图片,*.jpg;*.jpeg;*.png;*.bmp;*.wmf;*.jpe,All Files(*.*),*.*") '选择图片
With [B1].AddComment
.Shape.Fill.UserPicture Filename '向批注中插入图片
.Shape.Height = 150 '调整高度
.Shape.Width = 150 '调整宽度
End With
End Sub
Sub TEST()
Filename = Application.GetOpenFilename(fileFilter:="图片,*.jpg;*.jpeg;*.png;*.bmp;*.wmf;*.jpe,All Files(*.*),*.*") '选择图片
With [B1].AddComment
.Shape.Fill.UserPicture Filename '向批注中插入图片
.Shape.Height = 150 '调整高度
.Shape.Width = 150 '调整宽度
End With
End Sub