Hi!

I need your help to put a picture in an image section in a userform.

I copied and pasted-as-picture some cells (named Image1) in an Excel spread sheet ("Pic"), and I need that to be in the Userform in the Image1 box.
I am using this line of code for that:

Image1.Picture = LoadPicture(Worksheets("Pic").Shapes("Image1"))

When I try to run it, I have a mismatch error which makes me believe that maybe the copy/paste-as-picture format is not supported as image in the userbox...
I don't know what to do as the image has to come straight from the Excel document (continuously changing - but always named Image1)

Any advice on how to solve that?

Thanks!
Ched