vba code to show pictures in cells needed

[kelly mort]

Hello All,
I wanna find out if there is a way to use vba to pick pictures from a folder and place them in cells on a worksheet. By using IDs from cells to make lookups. That is say I have the dataset as:

Col A Col B
ID PIC
1001

So I will like the vba code use the ID 1001 to lookup the picture in the folder then show it under the PIC. The pictures will be named just as the IDs. If there is a better way of doing this let me know. Thanks
Kelly

 

[kelly mort]

If Pic1 is an image control, then it should work, but that would mean you having an image control for each name in the sheet and tying that image control to the name entered, is that what you want to do ????

Yes and it is working for now and faster than before. Thank you very much for your time and advice .

I have learned a lot from you.
Kelly

 

[MickG]

You're welcome