show and hide photos with formula

[jc83ph]

Hi Guys,

Good day. I need your help to fix this code. The code is work. But the issue only when i add the formula in column (fruit name) the picture not display. Please can you help this the small issue. Because i need to add formula in fruit based on the SN. The main value is C2 because that the name of photos.

Because some supplier send only the SN without the name of fruit. Then some supplier send item with barcode then I scanned the SN barcode from items. Then im using the vlookup from my database to find the name of fruit based on the SN.

Screen Shot 2021-06-09 at 10.26.01 AM.JPG

Here the code.

Please Login or Register  to view this content.

here the excel sample

[AlphaFrog]

The Worksheet_Change event does not trigger from a change in a formula. Only from a manual change. You manually change column D. The code should check if column D changes and then use the lookup value from the formulas in column C.

Not tested...

Please Login or Register  to view this content.

[jc83ph]

Thanks you for your response.

Anyway, i understand that need manual change.

my point is, there are many items arriving in my warehouse and I'm using scanner and excel with photos.

now, when i scanned the barcode item with serial no. like 123, 212, 111, etc. then the name of fruit display in C2, based on the SN in database file.

that why, i use the vlookup to find the name of fruit with SN to avoid manual enter. if i make copy and paste the fruit name in column C the photos display.

My point only during I scanned the SN automatic display the photos based on the name of fruit.

[AlphaFrog]

You scan the SN in column D, correct? That is a manual change that would trigger the Worksheet_Change event. Then it can display the fruit picture from the Vlookup in column C.

[jc83ph]

Hi thank you. is work. you're amazing.

Thanks you for your help.