I would like to create a worksheet where I can store information on number
of items. Each row of the worksheet would store data on 1 item only, and the
last cell of data would contain a link to an image of the item
(C:\Users\Dad\Desktop\test.png).

What I can not figure out is how to create the code to display the image in
an Image control on my Userform.

What I tried was:

Image1.Picture = Range("E3").Value

where Range("E3") contained C:\Users\Dad\Desktop\test.png.

Is this do able? If so could someone point me in the right direction.

Image1.Picture = LoadPicture(Range("E3").Value)

Depending on the way you have things arranged you might need to do something
like

Worksheets("Sheet1").OLEObjects("Image1").Object.P icture =
LoadPicture(Range("E3").Value

Regards,
Peter T



"ordnance1" wrote in message
...
I would like to create a worksheet where I can store information on number
of items. Each row of the worksheet would store data on 1 item only, and
the last cell of data would contain a link to an image of the item
(C:\Users\Dad\Desktop\test.png).

What I can not figure out is how to create the code to display the image
in an Image control on my Userform.

What I tried was:

Image1.Picture = Range("E3").Value

where Range("E3") contained C:\Users\Dad\Desktop\test.png.

Is this do able? If so could someone point me in the right direction.