How to Insert picture in excel from a folder

[Nirmall]

Hello Friends,

am trying to insert an image from a folder base on the value in cell A2, and the image should show on Cell O3

the image folder is D:\Labels\SPO\Ver2.0\Latest

Also everytime the value of cell A2 changes it should replace the earlier image

Please have a look, have attached the book with the vba code

[mjr veverka]

???

Please Login or Register  to view this content.

???

[Nirmall]

Awsome, worked Like a charm

[AliGW]

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

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

[Nirmall]

Done that @AliGW

thank u will follow the same next time as well

[Nirmall]

Hello mjr veverka,

this forum is just so awesome, have been getting tremendous solutions, have one more thing which i want in vba.

Now there is a sheet called "Metal 2L", in that there are two areas of data space. One is is yellow and the other one is in green.

Now if we go to the yellow area and select cell "I2" and from the drop down we select an option, the same corresponding image is shown in cell "H16".

For the above condition have inserted a vba code in the sheet u gave me, and it gives me the desired output.

Now if we come to the green area, would like that to work the same way as how it works in yellow area, meaning

in the green area if i select any value in cell "I35", and the corresponding image to show in cell "H49".

Now my question is how can i incorporate another vba code which will help in getting desired output in green area. (please note i also want the vba in yellow area to work as how it is working now)

Thank You

[mjr veverka]

Try:

Please Login or Register  to view this content.

[Nirmall]

Great, it worked like a charm, also if there is no image attached to a value, the older photo stays put, is there a way where if no image is available then it shows a blank image??

[mjr veverka]

For example:

Please Login or Register  to view this content.

For variant 2, prepare a file called "noimage.jpg" (or set your own name for the file without an image and enter it in the code).

[Nirmall]

Hello mjr veverka

am back again, jus come across a small bump in the code

Please Login or Register  to view this content.

in the above code my images load on cell C15 and cell C49 respectively,

i want the image to load on A23 and A57 respectively, can u please help as to waht changes i need to make in the code?

Please note rest everything else is working great in the code u gave

Regards