Programatically control picture property of Image control

I have a workbook with a table similar to this:
Item No. | Description | PicPath
ITEM1 | Item 1 description | C:/Images/a pic.jpg
ITEM2 | Item 2 description | C:/Images/another pic.jpg

On other sheets, I have vlookup functions calling records from the table. I also have image controls on those sheets, named the Item No.s (ITEM1, ITEM2).

Is there a way I can programatically loop through those images and set the picture property? This is the basic idea of what I want to do, but it doesn't work. How do I need to fix it? Thank you very much.

Please Login or Register  to view this content.

Figured out an answer to my own problem. I used the OLEobject and OLEobjects collection. Here's my code:

Please Login or Register  to view this content.