Specific comment (picture) on each specific item in a dropdown list

Hello! Everyone..I'm new here and I'm glad that there is this kind of forum. Very helpful for me since I'm interested in excel programming though I'm a bit new in Excel. My question is this.. Is there a way where I can assign a comment (picture) to specific term, not cell. Example, if I choose flower in a dropdown list, a picture of flower in a comment box will appear? I hope its possible. Thanks =)

Hello & Welcome to the board,

See if podcast 1172 could help you....

http://learnmrexcel.wordpress.com/2010/01/

Thanks for the follow up and glad it worked for you...you're welcome

If you are satisfied with the answer provided, please don’t forget to mark the thread as solved.

How to mark a thread Solved
Go to the first post
Select
-- Edit
-- Go Advanced
-- Below the word Title you will see a dropdown with the word No prefix
-- Update to Solved and then select Save

If you followed the directions exactly then maybe you should remove the end part (jpg).

Worked good for me.

newpic = "C:\aaa\Pics\" & Range("c7").Value & ".jpg"

I believe you can click edit and then manage attachments and upload.

Here is what I used and it worked fine.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$C$6" Then
        newpic = "C:\aaa\Pics\" & Range("C7").Value
        Target.Comment.Shape.Fill.UserPicture newpic
    End If
End Sub

Make sure the path with the files exists, you have you vlookup in C7, and the names of the files in column B. Also, make sure the code is in the worksheet module. Right click on the sheet tab and view code.

Again you are very welcome