Show and hide the pictures based on the value.

Hi, welcome to the forum.
If I understand you correctly you do not have any code yet?
The screenshots you have attached are manual actions?
Have you tried recording a macro for each action? Then you can edit it to your use.
I am not a MAC user and I know MAC VBA differs some, but if you record the macro you can attache the code (in code blocks) and then one of us could certainly help.

Hi Hans,

Thanks for your reply.
Yes, I don't have a code for that. That why I need your help. I'm not expert in programming.
Regarding the screenshot, yes the manual actions.
I try to recording a macro here the result the code

Please Login or Register  to view this content.

Hans, please help me to find this solution so that very easy to me about my work. Because I want to see automatic the picture from the box when I scan the value. Please note the picture connect from the computer or desktop.

Hi Hans,

Thanks for your reply.
Yes, I don't have a code for that. That why I need your help. I'm not expert in programming.
Regarding the screenshot, yes the manual actions.
I try to recording a macro here the result the code

Please Login or Register  to view this content.

Hans, please help me to find this solution so that very easy to me about my work. Because I want to see automatic the picture from the box when I scan the value. Please note the picture connect from the computer or desktop.

here the pictures inside the folder of my computer.

Screen Shot 2018-05-24 at 8.14.20 PM.jpg

Okay, I'll work with that and post code.
I'll have to do this on a Windows system but the code will be the same.
The Cell with the product name, you just enetr a name or do you want to enter the name in the same cell?

I want to enter the name in same cell (A1 - A10000 or more) and another column display or show the picture result when I enter the right name of picture.

i suggest if possible can you use the image box tool from developer so the picture can display in image box?

And also I need also additional code for "no picture available" if the name not correct.

you say A1 - A10000, does this mean that the picture must be displayed next to the name?
Can you explain the idea little, I don't imagine you want all 10000 pictures displayed at the same time.
How are you triggering this?

yes your correct the picture must be display next to the name. Mean hide and show the picture based on the name.
example:
A1 - apple - show picture
next
A2 - banana - show picture then the apple picture to be hide.

Because my job is enter the name of each item then I want to see the picture of item in the image box if that correct based on the physical item.

Every time I enter the name of item automatic show and hide the picture in image box.

I hope you got my point.

You'll have your reason to do it the way you want.
This macro code should go into the Workheet's VBA and will be triggered by a right-click in Column A and if there is a value in it it will trigger.
You will have to check path wbPath and the photopath thsi last one is the folder where the pictures will be found.
I attached my Excel file as a sample and also a NOPHOTO.jpg for the PHOTO NOT AVAIBALE, plce this one in the images or picture folder

Please Login or Register  to view this content.

Hi,

Thanks for your help. I open your sample but the pictures not showing. Sorry I'm not good in programming.

By the way, I have a question. where can i put the path folder?

This is my path folder. /Users/jcsc83ph/Desktop/sample of my computer.

If you read the code part you can see where the path goes

Please Login or Register  to view this content.

The variable wbPath uses the actual path where this workbook is in (I hope a MAC understands this too)
If your photos are in another path that you make sure that the variable photoPath = "..." point to that correct path

And it it is not showing then there is nothing in that path.

Without a little programming knowledge, well I cannot build it all for you, you need to do some on your side, check Google read up on it.
The basics are correct they work

I try to run this in excel window here the result:
Picture1.png

And the code

HTML Code: 

another question if possible the right click command can remove? I mean every time I enter the name of item automatic show the picture in column b no need to press the right click.

Yes, just remove it in the worksheets event but keep in mind that my macro is triggered by this.

The name is case sensitive
So make sure the photo name is the same case as what you enter

Please don't reply with quote.
Just reply and type and copy and paste a section as quote if required, makes it easier to read

And this is sufficient for the path

Please Login or Register  to view this content.

Your code modified, test to see if it works

Please Login or Register  to view this content.

If interested in a non-vba approach...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

jefferybrown's solultion without VBA is great, but have you checked the size the Excel file? the more pictures (depending on their resolution the bigger it gets and it's not dynamic in the sense you always have to manually import a picture set in the sheet, give it a name.
The vba solution makes it dynamic in that sense that you can keep adding adding pictures / images to the folder and just type the name in the Excel sheet
But I agree, no vba makes life easier for non-vba addicts