• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

select picture with list

K

kalpeshpatel

New Member
in sheet1


contain customer name & i create a list of customer name


a1 cell contain list


now ,


i select name of customer in list, photo of customer is shwon in b1 cell


please vba help or macro for this
 
Hi Kalpesh ,


Where are the customers' photos stored ? Are they on disk or are they in your Excel worksheet ?


If they are in the same Excel worksheet as the customers' names , then a similar question was posed in this forum earlier ; check out :


http://chandoo.org/forums/topic/how-to-pull-images-with-vlookup-or-offset-without-macro


Narayan
 
Hi, kalpeshpatel!


Have you searched for this problem at chandoo's website? In the upper right corner of this page there's a search text box and it's a very useful tool.


In the same green sticky post I mentioned you in other topic few minutes ago, you'll find something like this:

"Quickly search the Web and Chandoo.org for help before posting. It is quite possible that your problem has been solved by someone else."


Recently there has been another similar case, check this:

http://chandoo.org/forums/topic/insert-photos-in-excel-upon-name-change-in-a-cell

There is an uploaded file that performs what you're asking for. Just advise if any trouble downloading it.


Regards!
 
Hi, kalpeshpatel!


Your very brief comment just helps a only little but not enough. And the main idea of posting is helping others to aid you.


In the link I posted you have a full operating workbook for managing names, data and photos. It includes VBA code to perform the non-formula operations. If the only observation you've found is changing the picture source, it's as simply as changing the two ocurrences of this string:

-----> sPicture = ActiveWorkbook.Path + "Photos"

by this one:

-----> sPicture = "D:"


If you can't manage to handle it, advise and I'll resend it fixed for you.


But -and it's what I fear- your workbook requirements are slightly different, in order to avoid them raising in a one-after-one basis, please consider uploading your file so as to check it and making the correct adjustments.


Refer to the green sticky posts at this forums main page if help needed for uploading.


Regards!
 
You must log in or register to reply here.
Back
Top