Sep 22 2021 03:44 AM
I want to display image for column with content URL Hope the helping. thanks a lot.
Sep 22 2021 03:59 AM - edited Sep 22 2021 04:03 AM
It required VBA for that. Also a frame to show the image.
One sugestion is using cell comments as frame. So when the user hover the mouse an image is shown.
Considering cell B2 with the image path you can type on C2 the following UDF
Public Function AddCommentWithImage(ByRef ImagePath As String)
Dim rng As Range, cmt As Comment
Set rng = ActiveCell
If Not (rng.Comment Is Nothing) Then rng.Comment.Delete
Set cmt = rng.AddComment
cmt.Text Text:=""
With cmt.Shape
.Fill.UserPicture ImagePath
.Width = 481.5864
.Height = 359.7734
End With
End Function
Sep 22 2021 05:38 AM
Sep 22 2021 05:52 AM
Sep 22 2021 06:00 AM
Sep 22 2021 06:37 AM - edited Sep 22 2021 06:56 AM
I agree with you! i am having problem when i select column "avata". it does not display the image, the path is " [@[name.1]].avata " i want to show the image in this case, not the path