I'm trying to determine if a cell contains a comment with a picture. While I tried this way and it failed, any which way that works would be fine.
I found this code:
https://stackoverflow.com/questions/22543601/determine-image-in-excel-comment
which I think does check if a comment contains a picture.
However, I get an error message pointing to Fill.
my version of this code:
The picture of the error is here.
https://www.dropbox.com/s/uoa453t6dj6ji2s/Screen Shot 2019-07-31 at 10.08.28 PM.png?dl=0
my environment ecel 2011. macOS 10.10.5
I found this code:
Code:
<code>Set shp = Range("C4").Comment.Shape
if shp.Fill.TextureType = msoTextureUserDefined then
end if</code>
https://stackoverflow.com/questions/22543601/determine-image-in-excel-comment
which I think does check if a comment contains a picture.
However, I get an error message pointing to Fill.
my version of this code:
Code:
Sub testFunction()
Dim shp As Range
Debug.Print " checking for shape "
Set shp = Range("b4").Comment.Shape
If shp.Fill.TextureType = msoTextureUserDefined Then
Debug.Print "shape found"
End If
End Sub
The picture of the error is here.
https://www.dropbox.com/s/uoa453t6dj6ji2s/Screen Shot 2019-07-31 at 10.08.28 PM.png?dl=0
my environment ecel 2011. macOS 10.10.5