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 =)
Last edited by freesa; 05-21-2011 at 11:32 PM.
Hello & Welcome to the board,
See if podcast 1172 could help you....
http://learnmrexcel.wordpress.com/2010/01/
HTH
Regards, Jeff
Hello Jeff!
That was prompt. Exactly what I'm looking for. Super thanks =)
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
hello!
One more thing. I thought it'll work once i followed the instruction from the podcast, unfortunately I can't make it work. Could you please look at my script and see if there's something wrong with it. Here it is..
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$c$6" Then
newpic = "C:\aaa\Pics\" & Range("c7").Value & ".jpg"
Target.Comment.Shape.Fill.UserPicture newpic
End If
End Sub
If you followed the directions exactly then maybe you should remove the end part (jpg).
Worked good for me.
Please Login or Register to view this content.
Hello Jeff,
Thanks for your patience. Actually I played with the code and insert the ".jpg" part hoping I can make it work since i can't make it work with the original script. I want to show you the excel file that i made but unfortunately i don't how to attach it here.
I believe you can click edit and then manage attachments and upload.
Here is what I used and it worked fine.
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.Please Login or Register to view this content.
Last edited by jeffreybrown; 05-21-2011 at 11:20 PM.
Re: Specific comment (picture) on each specific item in a dropdown list
Hi!
It worked fine now, though I still don't know what went wrong before. Thank you very much. It's really nice to know that there are some people willing to help others for free.
God bless Jeff
Again you are very welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks