UserForm / image show based on the link from cell

Dear All,

I am looking for, most probably, simple vba code.
I have a sheet called "Basic data" and in the cell D80 I have a path for an image.
"c:\movies\matrix.jpg"

D80 holds a formula vlook and find this link in the other sheet.

I would like to load an image from D80 to the Image1 on UserForm1.
I was digging for an answer over the Internet but I have not found proper code...

Please Login or Register  to view this content.

based on that code i got "File not found"

2nd question is where to put the code? to the Sheet Code or keep it in the UserForm5.

Thanks in advance for the suggestiosn!

The value of D80 is a complete file path with extension, i.e. "c:\movies\matrix.jpg"
Adding [& ".jpg"] in this line of your code doubles .jpg in that

Please Login or Register  to view this content.

and the path becomes "c:\movies\matrix.jpg.jpg"
Just remove [& ".jpg"] and add "Set" keyword preceding this line:

Please Login or Register  to view this content.

i would probably leave it in the userform module - run it from the activate event?