So I need some way to lookup/automatically insert, based on name or other criteria, several hundred photos.

I am not new to Excel, but I am new to the whole VBScript deal.

Here is one way of doing it. My code is below. However, I am getting "Run-time error '5': Invalid procedure call or argument" and it is highlighting the "Target.Comment.Shape.Fill.UserPicture NewPic" Line. Could this be because of some incompatibility of VB to lookup files in OS X? Or Possibly the way to set a picture in a comment is different?

http://www.5min.com/Video/How-to-Do-...xcel-241920860

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$E$3" Then
NewPic = "~/Desktop/MarketRankerPics/" & Range("Q39").Value
Target.Comment.Shape.Fill.UserPicture NewPic
End If

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Thank You!
Andy