Hello
I am new to excel and have a spreadsheet that pulls a picture from a file when you change the contents of the cell. I would like to be able to have this cell use a vlookup function to control its contents thereby changing the picture when an alternate cell is changed. So far I have this but it does not work. Any help would be greatly appreciated.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim updatedCell As Range
Set updatedCell = Range("F3")
If (updatedCel) = ("F3") Then
NewPic = "C:\users\kekrk23\desktop\" & Range("C7").Value
Target.Comment.Shape.Fill.UserPicture NewPic
End If
End Sub
Bookmarks