Refer to oleobject picture in worksheet from VBA

[Jaymond Flurrie]

I want a picture in a form take it's picture (i.e. the actual image) from either of the two oleobject images I've saved into a workbook.

The pictures (picArrowUp / picArrowDown) are in sheet shtVar and the image element in the form is imgTrend

so

imgTrend.Picture = shtVar.OLEObjects.Picture("picArrowUp")

which results as "Object doesn't support this property or method.

I'm pretty sure I'm not far from working code, but could you solve the last bit for me?

Thanks

 

[Jaafar Tribak]

Now that I look forward to with great interest!