Show picture of cell in Userform

[bullshot25]

Hi all,

I was wondering if one can show a picture of a cell in a userform.

You can take a picture of a cell (select the cell > copy > paste special > picture) and you can show pictures in userforms, I just don't know how I can show the picture of that cell in a userform.

The reason why I want to show the cell-content in a picture and not in a textbox is because the cell is formatted and I don't want to lose the formatting when showing the text in the userform. The text does not have to be adjustable.

Anyone knows how to do this?

Cheers

[MickG]

Copy the range using "Ctrl +C"
Paste into Userform properties list , against "Picture" , using "Ctrl +V"

[bullshot25]

Hi MickG,

And how can I do this for multiple cells?

The idea is that you would call a userform for a specific row and that you would see a cell depicted specifically for that row. So the picture will be different everytime the userform would be called.

I was thinking to, when the userform is called, copy-paste the corresponding cell in another column and use the new cell containing the actual picture to fill the picture in the userform. You know perhaps how to do this? Put a picture that is in a cell into a userform?

[Andy Pope]

See PastePicture example
http://www.oaltd.co.uk/Excel/Default.htm

[MickG]

The example Below Creates a file which is held on "Thisworkbook.path" ,using the Camera tool.
When opening the "Userform" you select a range from the dropdown and the code will fill the "Image"Control on the U'Form.

[bullshot25]

Thanks guys! Works like a charm!