Put image in VBA userform from Copy/Paste - Mismatch error

[Ched9]

Hi!

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

I copied some cells and pasted-as-picture (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

 

[My Aswer Is This]

I really do not think you can do that.
Why not have a Multicolumn listbox

 

[Ched9]

I am using conditional formatting in the original cells, it's quite graphic...
When I tried the multicolumn listbox , only the data would show and not the layout of the cells :/

 

[My Aswer Is This]

That is true. Maybe some one else has an answer but I believe I have seen this qusestion before and have never seen an answer to meet you needs.

I am using conditional formatting in the original cells, it's quite graphic...
When I tried the multicolumn listbox , only the data would show and not the layout of the cells :/

 

[Jaafar Tribak]

Do a forum search for the word OleCreatePictureIndirect .. You'll find some examples that hopefully you can adapt to your need

 

[My Aswer Is This]

I did a forum search on:
OleCreatePictureIndirect

and it came back with nothing.

Do a forum search for the word OleCreatePictureIndirect .. You'll find some examples that hopefully you can adapt to your need

 

[Jaafar Tribak]

I did a forum search on:
OleCreatePictureIndirect

and it came back with nothing.

Take a look here :
https://www.mrexcel.com/forum/excel-questions/566836-display-range-cells-worksheet-userform.html