VlookUp Image on Userform

[Ryan_Bernal]

Good day!
Just wan to ask if it is possible to vlookup value on text box and display the image on image1.picture?

Please Login or Register  to view this content.

Here is work book:
VlookUp picture.xlsm

Thanks in advance.

[Norie]

What exactly are you looking up?

Is if the path and filename of the image?

[Ryan_Bernal]

Hello Norie,
Thanks for the response.
i Just want to display the image of the lookup value on userform.
Is it possible?
Sorry i forgot to open empLog form

Please Login or Register  to view this content.

[Norie]

But what will the lookup actually return?

It can't return an image.

[Ryan_Bernal]

the lookup value should rturn an image on userform.
For example.
Code Fullname Department Designation Photo
IN129 A B C IMAGE.JPG

if i enter the Employee Code (IN129), employee name should appear on txtEmp (A) and IMAGE.JPG should appear on image (photo)

empLog form.JPG

Is there any solution for this?

[Norie]

So the VLOOKUP returns the name of the image file.

Do you have the path to the image file(s)

If you did you could use LoadPicture

Please Login or Register  to view this content.

[Ryan_Bernal]

Hello Norie,
Wwaht do you by "Path to the image file?
I put all the photos to C:\Users\Ryan\Desktop\Images
and i place that on my worksheets using insert.

For example:
code Name Photo
IN129 name name.jpg
IN130 name2 name2.jpg

[Norie]

This is the path:

C:\Users\Ryan\Desktop\Images

Change the code I posted to reflect that - I've commented where to do that.

[Ryan_Bernal]

This is the path:

C:\Users\Ryan\Desktop\Images

Change the code I posted to reflect that - I've commented where to do that.

Thank you Norie for your response.
Unfortunately, i got an error runtime error 53 "File not found".
I already put the images inside "C:\Users\Ryan\Desktop\Images"
By the way, this is how I inserted the Photos.
Menu tab-->Insert--> Picture and i resize/drag it opposite to given employee (photo column).

[Ryan_Bernal]

Problem Solved!
I changed this code

Please Login or Register  to view this content.

into this

Please Login or Register  to view this content.

to read the extension file

[Norie]

So you didn't have the full filename in the cell.