Hi everybody,
I have a folder store all employee's pictures. All pictures are named staff ID, for example: 123.jpg 456.jpg...
Now, I would like to show employee picture automatically when I input a staff ID in cell.
For instance: When I input 123 in cell D2, the employee picture 123.jpg will auto-show in the B2 area, something like that.
Could you please give me the best way? Thank you so much.
Hi phan sang
Here's one way...For test purposes, i inserted the Staff Id's in Column H and the corresponding Picture name in Col J.
Put the code in the sheet module that contains your information.
Right click on sheet tab, view code and paste in...
As you enter the staff id in D2 it will look for the corresponding Pic associated with that Id in Range J and then attach the image stored in your path.
Please Login or Register to view this content.
Last edited by sintek; 07-24-2017 at 04:16 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
You need to define the correct file path for your computer, I believe.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
As AliGW says...Have you changed this path to your path that the staff images are stored in...
Please Login or Register to view this content.
yes, my codes are now:
1004.pngPlease Login or Register to view this content.
Could you please help me revise? Thank you so much.
Please upload a sample of your workbook...Where have you stored the staff Id's and staff Picture names... as per below code
Please Login or Register to view this content.
Hi,
You have too many backslashes in the path that way. Change
toPlease Login or Register to view this content.
Note that because you are using a server location, you will end up with a linked picture this way, rather than an embedded one. If you need it to be embedded, you should use Shapes.AddPicture rather than Pictures.Insert which is actually deprecated.Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi all,
I tried changing Path like your instructions but it cannot.
In cell D2, I used validation feature to list Staff ID in Sheet Employee List. In cell D2, I can press or choose Staff ID from list.
Employee Pictures is being stored in the path: \\servername\EmployeePic$ with names: 123.jpg; 456.jpg, 789.jpg....
1004.png
See post 7......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks